다음을 통해 공유


Workbook.SheetSelectionChange Event (Excel)

Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).

Syntax

.SheetSelectionChange(Sh, Target)

An expression that returns a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

Sh

필수

Object

The worksheet that contains the new selection.

Target

필수

Range

The new selected range.

Example

This example displays the sheet name and address of the selected range in the status bar.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _ 
 ByVal Target As Excel.Range) 
 Application.StatusBar = Sh.Name & ":" & Target.Address 
End Sub

참고 항목

개념

Workbook Object Members

Workbook Object