Change Event [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
Worksheet.Change Event
Occurs when cells on the worksheet are changed by the user or by an external link.

Syntax

expression.Change(Target)

expression   A variable that represents a Worksheet object.

Parameters

NameRequired/OptionalData TypeDescription
TargetRequiredRangeThe changed range. Can be more than one cell.

Return Value
Nothing

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.

Visual Basic for Applications
Private Sub Worksheet_Change(ByVal Target as Range)
    Target.Font.ColorIndex = 5
End Sub

See Also