MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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