SheetChange Event

See Also         Example         Applies To

Occurs when cells in any worksheet are changed by the user or by an external link.

Syntax

Private Sub object_SheetChange(ByVal Sh As Object, ByVal Source As Range)

object   Application or Workbook. For more information about using events with the Application object, see Using Events with the Application Object.

Sh   A Worksheet object that represents the sheet.

Source   The changed range.

Remarks

This event doesn't occur on chart sheets.