Change Cell Event
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = ActiveSheet.Range("$A$2") Then
MsgBox "Hello"
End If
End Sub
substitute the msgbox with your code.......
hope that helps!
:)
susan
On Nov 3, 12:19*pm, snax500 wrote:
How do I code an event change macro that triggers when cell A2 is
changed.
Thanks
|