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