DocEvents_PivotTableBeforeAllocateChangesEventHandler Delegate

A Delegate type used to add an event handler for the PivotTableBeforeAllocateChanges event. The PivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
<ComVisibleAttribute(False)> _
Public Delegate Sub DocEvents_PivotTableBeforeAllocateChangesEventHandler ( _
    TargetPivotTable As PivotTable, _
    ValueChangeStart As Integer, _
    ValueChangeEnd As Integer, _
    <OutAttribute> ByRef Cancel As Boolean _
)
'Usage
Dim instance As New DocEvents_PivotTableBeforeAllocateChangesEventHandler(AddressOf HandlerMethod)
[ComVisibleAttribute(false)]
public delegate void DocEvents_PivotTableBeforeAllocateChangesEventHandler(
    PivotTable TargetPivotTable,
    int ValueChangeStart,
    int ValueChangeEnd,
    out bool Cancel
)

Parameters

  • Cancel
    Type: System.Boolean

    false when the event occurs. If the event procedure sets this parameter to true, the changes are not applied to the PivotTable and all edits are lost.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace