Worksheet.SelectionChange Event (Excel)

Occurs when the selection changes on a worksheet.


expression. SelectionChange( _Target_ )

expression A variable that represents a Worksheet object.


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


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

Worksheet Object