WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler Delegate

A Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges 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 WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler ( _
    Sh As Object, _
    TargetPivotTable As PivotTable, _
    ValueChangeStart As Integer, _
    ValueChangeEnd As Integer, _
    <OutAttribute> ByRef Cancel As Boolean _
)
'Usage
Dim instance As New WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler(AddressOf HandlerMethod)

[ComVisibleAttribute(false)]
public delegate void WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler(
    Object Sh,
    PivotTable TargetPivotTable,
    int ValueChangeStart,
    int ValueChangeEnd,
    out bool Cancel
)

Parameters

• Sh
  Type: System.Object

  The worksheet that contains the PivotTable.

• TargetPivotTable
  Type: Microsoft.Office.Interop.Excel.PivotTable

  The PivotTable that contains the changes to apply.

• ValueChangeStart
  Type: System.Int32

  The index to the first change in the associated PivotTableChangeList collection. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.

• ValueChangeEnd
  Type: System.Int32

  The index to the last change in the associated PivotTableChangeList collection. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.

• Cancel
  Type: System.Boolean

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

See Also

Reference

Microsoft.Office.Interop.Excel Namespace