SheetSelectionChange Event [Excel 2003 VBA Language Reference]

  • Article

Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).

Private Subobject**_SheetSelectionChange(ByValShAs Object**, ByValTargetAs Excel.Range)

objectApplication or Workbook. For more information about using events with the Application object, see Using Events with the Application Object .

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

Applies to | Application Object | Workbook Object