Workbook.SheetSelectionChange Event

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
        ByVal Target As Excel.Range)
    Application.StatusBar = Sh.Name & ":" & Target.Address
End Sub

See Also