Workbook.SheetSelectionChange Event (Excel)
Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
Syntax
식 .SheetSelectionChange(Sh, Target)
식 An expression that returns a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Sh |
필수 |
Object |
The worksheet that contains the new selection. |
Target |
필수 |
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