This code is worksheet event code so it must be posted into the sheet. Right
click the approporate tab and select View Code. Paste the following...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 15 And UCase(Target.Value) = "Y" Then
MsgBox "Run your macro"
End If
End Sub
--
HTH...

Jim Thomlinson


"saman110 via OfficeKB.com" wrote:

How can I create a macro that whenever I type "y" or "Y" in "O" column, it
run a macro.

thx.

--
Message posted via http://www.officekb.com