Another easy question!

[Overkill32]

How can you make a macro run when you change the value of a specific cell? For exemple, if I currently had the value "3" or "Hello" in cell A1, how can i make my macro "TestMacro()" run when i change the cell?​

 

[VoG]

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 TestMacro
End Sub