SheetSelectionChange Event
Applies To
Application object, Workbook object.
Description
Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
Syntax
Private Sub object_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
object Application or Workbook.
Sh The worksheet that contains the new selection.
Target 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