Occurs when cells in any worksheet are changed by the user or by an external link.
Syntax
expression.SheetChange (Sh, Target)
expression An expression that returns an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Sh | Required | Object | A Worksheet object that represents the sheet. |
| Target | Required | Range | The changed range. |
Remarks
This event doesn't occur on chart sheets.
Example
This example runs when any worksheet is changed.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Source As Range)
' runs when a sheet is changed
End Sub