Workbook.SheetSelectionChange event (Excel)
Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
Syntax
expression.SheetSelectionChange (Sh, Target)
expression An expression that returns a Workbook object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Sh | Required | Object | The worksheet that contains the new selection. |
| Target | Required | Range | The new selected range. |
Example
This example displays the sheet name and address of the selected range in the status bar.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
Application.StatusBar = Sh.Name & ":" & Target.Address
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.