Worksheet.SelectionChange Event (Excel)

Occurs when the selection changes on a worksheet.

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.

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
Show:
© 2014 Microsoft