Worksheet.SelectionChange Event (Excel)

Occurs when the selection changes on a worksheet.

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.

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
 With ActiveWindow 
 .ScrollRow = Target.Row 
 .ScrollColumn = Target.Column 
 End With 
End Sub

See Also

Concepts

Worksheet Object

Worksheet Object Members