How do I execute a macro every time a particular cell is changed.
Posted by JC - Miami on September 24, 2001 8:32 AM
How do I execute a macro every time a particular cell is changed.
Thanks,
JC.
Posted by Juan Pablo on September 24, 2001 8:38 AM
Try this on your worksheet event code
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$A$3" Then Yourmacro
End Sub
Change the "$A$3" for the cell you want and also change "Yourmacro" with the name of the macro you want to execute.
Juan Pablo
