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