Excel VBA: Check When Cell Changes 1

[TonyRosen]

How do I use VBA etc.. to determine when a specific cell changes and then run a macro if it does?

 

[PHV]

Have a look at the Change event of the Worksheet object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TonyRosen]

Yeah ... tried that ... it won't fire off. No sweat - I'll go off surfing for an answer.

 

[TonyRosen]

Yea! I'm a superstar:

Sub Worksheet_Change(ByVal Target As Range)
Dim WatchRange As Range
Dim IntersectRange As Range
Set WatchRange = Range("A1:A10")
Set IntersectRange = Intersect(Target, WatchRange)
If IntersectRange Is Nothing Then
'Do Nothing Spectacular
Else
Call MyMacro
End If
End Sub

 

[taupirho]

Yea! I'm a superstar:

Yes, its amazing what you can achieve by following someone else's answer to your question!!

Have a star PHV

 

[TonyRosen]

tomreid, i came up with my answer before reading PHV's response ... so, I'm still a superstar ... HA!

 

[taupirho]

Actually, PHV gave you the answer. You said you tried his solution but couldn't get it to work. Then you came back and said you found the solution - which you had already been ... sigh OK you ARE a superstar, well done !!

 

[TonyRosen]

Good grief ... nevermind .... now I remember why i stopped coming around here .....