Compartilhar via

Worksheet.SelectionChange Event

  • Artigo
Excel Developer Reference

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.

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

See Also