WorkbookEvents_SheetChangeEventHandler Delegate
A Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)
Usage
Sub Sub1(Sh As Object, _
Target As Range)
End Sub
Dim workbookEvents_SheetChangeEventHandler1 As New WorkbookEvents_SheetChangeEventHandler(AddressOf Sub1)
Syntax
Public Delegate Sub WorkbookEvents_SheetChangeEventHandler( _
<InAttribute()> ByVal Sh As Object, _
<InAttribute()> ByVal Target As Range _
)
public delegate void WorkbookEvents_SheetChangeEventHandler(
[In] object Sh,
[In] Range Target
);
public delegate Void WorkbookEvents_SheetChangeEventHandler(
Object^ Sh,
Range^ Target
);
public delegate void WorkbookEvents_SheetChangeEventHandler(
/*in*/System.Object Sh,
/*in*/Range Target
);
In JScript, you can use the delegates in the .NET Framework, but you cannot define your own.
Parameters
- Sh
A Worksheet object that represents the sheet.
- Target
The changed range.
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000