title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
Workbook.SheetChange event (Excel) |
vbaxl10.chm503091 |
|
|
37e727d8-255c-ac23-45d8-13a8e7639991 |
05/29/2019 |
medium |
Occurs when cells in any worksheet are changed by the user or by an external link.
expression.SheetChange (Sh, Target)
expression An expression that returns a Workbook object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Sh | Required | Object | A Worksheet object that represents the sheet. |
Target | Required | Range | The changed range. |
This event doesn't occur on chart sheets.
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
[!includeSupport and feedback]