AppEvents_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 appEvents_SheetChangeEventHandler1 As New AppEvents_SheetChangeEventHandler(AddressOf Sub1)

Syntax

Public Delegate Sub AppEvents_SheetChangeEventHandler( _
    <InAttribute()> ByVal Sh As Object, _
    <InAttribute()> ByVal Target As Range _
)
public delegate void AppEvents_SheetChangeEventHandler(
    [In] object Sh, 
    [In] Range Target
);
public delegate Void AppEvents_SheetChangeEventHandler(
    Object^ Sh, 
    Range^ Target
);
public delegate void AppEvents_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

Target Platforms

See Also

Reference

Microsoft.Office.Interop.Excel Namespace