Can a macro run on a cell-change event?

[Hitesh_Banda]

Hi,

Just curious about the question, can I have a macro which runs whenever a cell-value is changed? If so, How can I do it?

Thanks,
Hitesh.

 

[VoG]

Hi. Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "A1" Then Call MyMacro
End Sub

MyMacro will be run when you change A1.