Skip to main content

Worksheet.SelectionChange event

Table of contents
  1. Syntax
  2. Parameters
  3. Example

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>