Export (0) Print
Expand All

DocEvents_Event.Change Event 

Occurs when cells on the 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
WithEvents docEvents_Event1 As DocEvents_Event
Function docEvents_Event1_Change(Target As Range) As Void
	Handles docEvents_Event1.Change
End Function

event DocEvents_ChangeEventHandler Change;
 void add_Change(DocEvents_ChangeEventHandler handler);
 void remove_Change(DocEvents_ChangeEventHandler handler);
In JScript, you can handle the events defined by a class, but you cannot define your own.

This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation.


Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft