Auto run a macro when a cell in workbook changes

[Kourada]

If cell "a1" changes, I want a macro to run automaticly. How do I write that?

Thanks
C. Kaloudis
hios@interaccess.com

 

[John McGraw]

On 2002-04-23 11:39, Kourada wrote:
If cell "a1" changes, I want a macro to run automaticly. How do I write that?

Thanks
C. Kaloudis
hios@interaccess.com

Put this in the module for the worksheet where you want the change to be monitored:

<font size =-1>

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
MyMacro
End If
End Sub