0 out of 5 rated this helpful - Rate this topic

Worksheet.SelectionChange Event

Visual Studio 2005

Occurs when the selection changes on a worksheet.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

Syntax

Copy

public event DocEvents_SelectionChangeEventHandler SelectionChange

Example

The following code example demonstrates a handler for the SelectionChange event that displays the sheet name and address of the selected range in the status bar.

Copy

private void WorksheetSelectionChange()
{
    this.SelectionChange += 
        new Excel.DocEvents_SelectionChangeEventHandler(
        Worksheet1_SelectionChange);
}

void Worksheet1_SelectionChange(Excel.Range Target)
{
    this.Application.StatusBar = this.Name + ":" +
        Target.get_Address(missing, missing,
        Excel.XlReferenceStyle.xlA1, missing, missing);
}

Reference

Worksheet Class
Worksheet Members
Microsoft.Office.Tools.Excel Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)