Worksheet.SelectionChange Event

Syntax

expression.SelectionChange(Target)

expression A variable that represents a Worksheet object.

Parameters

Name	Required/Optional	Data Type	Description
Target	Required	Range	The new selected range.

Example

This example scrolls through the workbook window until the selection is in the upper-left corner of the window.

Visual Basic for Applications
`Private Sub Worksheet_SelectionChange(ByVal Target As Range) With ActiveWindow .ScrollRow = Target.Row .ScrollColumn = Target.Column End With End Sub`

selection selection change Selection Change Event selectionchange selectionchange event When selection changes on a worksheet?

Occurs when the selection changes on a worksheet.