How do I detect the cell data change?

Hello experts.

My question is:

How do I detect the cell data change in order to run a Macro when this happens?

Example:

If data in cell D5 changes then run Macro1

I'm using Excel 2003. Thanks in advance.

I was trying the code but it did not work for me, and finally with a little change, it worked fine, like this:


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "D5" Then
Macro1
End If

End Sub


Thanks for your help.

Please edit your post to add cde tags.

I was trying the code but it did not work for me, and finally with a little change, it worked fine, like this:

Please Login or Register  to view this content.

Thanks for your help.