right click sheet tabview codeinsert thisSAVE
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" And UCase(Target) = "X" Then MsgBox "HI"
End Sub

--
Don Guillett
SalesAid Software

"JasonK" wrote in message
...
TIA - everyone that helps in this group is awesome. thanks so much
for your help.


i would like to know, and i can't find it in my books, if it is
possible to run a macro when a cell returns a certain criteria.

for example, if range("A1") = x then application.run "macro1"

if so, where do i put the code?

jasonk