This documentation is archived and is not being maintained.

Worksheet.Change Event

Office 2007
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



Show: