SheetSelectionChange Event

         Example         Applies To

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. 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.