Change Event [Excel 2003 VBA Language Reference]
Occurs when cells on the worksheet are changed by the user or by an external link.
Private Sub Worksheet_Change(ByValTargetAs Range)
Target The changed range. Can be more than one cell.
Remarks
This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation.
Example
This example changes the color of changed cells to blue.
Private Sub Worksheet_Change(ByVal Target as Range)
Target.Font.ColorIndex = 5
End Sub
Applies to | Worksheet Object
See Also | Calculate Method | SheetChange Event