Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Occurs when the selection changes on a worksheet.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public Event SelectionChange As DocEvents_SelectionChangeEventHandler
public event DocEvents_SelectionChangeEventHandler SelectionChange
Examples
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.
This example is for a document-level customization.
Sub Worksheet1_SelectionChange(ByVal Target As Excel.Range) _
Handles Me.SelectionChange
Me.Application.StatusBar = Me.Name & ":" & _
Target.Address(ReferenceStyle:=Excel.XlReferenceStyle.xlA1)
End Sub
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);
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.