MrExcel Publishing
Your One Stop for Excel Tips & Solutions

auto fire a macro

Posted by Matt on February 20, 2001 1:17 PM

I would like to fire a macro whenever the values in a column are changed. I am thinking of using the "Worksheet_Change" method, but cannot make it fire. Help please.

Posted by JAF on February 20, 2001 2:42 PM

You're on the right track, but the following should point you n the right direction:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
MsgBox "Changed Column A"
End If
End Sub

Hope this helps.


Posted by Matt on February 21, 2001 5:47 AM

Thanks very much. I owe you a beer. It worked perfectly.