ListObjectChangeHandler Delegate
Represents the method that will handle the Change event of a ListObject.
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
public delegate void ListObjectChangeHandler( Range^ targetRange, ListRanges changedRanges )
Parameters
- targetRange
-
Type:
Microsoft.Office.Interop.Excel::Range^
The Range that the change occurred in.
- changedRanges
-
Type:
Microsoft.Office.Tools.Excel::ListRanges
The areas of the ListObject that contain changes.
When you create a ListObjectChangeHandler delegate, you identify the method that will handle the event. To associate the event with your event handler, add an instance of the delegate to the event. The event handler method is called whenever the event occurs unless you remove the delegate.
The following code example creates a ListObject and a Change event handler. To raise the Change event, add text to one of the cells in the ListObject and then press ENTER.
Show: