Run Macro when a Cell Changes in Excel

[cyork]

Is there a way to have a macro execute everytime the value in a given cell is changed???

Thanks,

Chris

 

[dsi]

Use the Worksheet_Change event to monitor your target cells. Then, if the target cell is changed, just call your macro.

 

[vbMax]

You can use the Worksheet_Change event. In the example
below, "yourProcedure" is executed whenever cell A1 is
changed.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = Range("A1&quot.Address Then
Call yourProcedure
End If
End Sub