Class ValueChange (Excel VBA)

The class ValueChange represents a value that has been changed in a PivotTable report that is based on an OLAP data source.

Member in collection


To use a ValueChange class variable it first needs to be instantiated, for example

Dim vlc as ValueChange
Set vlc = ActiveCell.PivotTable.ChangeList(Index:=1)

The following procedures can be used to set variables of type ValueChange: PivotTableChangeList.Add and PivotTableChangeList.Item.

For Each

Here is an example of processing the ValueChange items in a collection.

Dim vlcChangeList As ValueChange
For Each vlcChangeList In ActiveCell.PivotTable.ChangeList
Next vlcChangeList

PivotTableChangeList.Add - Adds a ValueChange object to the specified PivotTableChangeList collection.

Delete - Deletes the specified ValueChange object from the PivotTableChangeList collection.


PivotTableChangeList.Item (Default member) - Returns a single ValueChange object from the specified PivotTableChangeList collection.

PivotTableChangeList.Count returns a Long value that represents the number of objects in the collection.

AllocationMethod returns the method to use to allocate this value when performing what-if analysis.

AllocationValue returns the value to allocate when performing what-if analysis.

AllocationWeightExpression returns the MDX weight expression to use for this value when performing what-if analysis.

Order returns a value that indicates the order in which this change was performed relative to other changes in the PivotTableChangeList collection.

PivotCell returns a PivotCell object that represents the cell (tuple) that was changed.

Tuple returns the MDX tuple of the value that was changed in the OLAP data source.

Value returns the value that the user entered in the cell or that the formula in the cell was evaluated to when the UPDATE CUBE statement was last run against the OLAP data source.

VisibleInPivotTable returns whether the cell (tuple) is currently visible in the PivotTable report.

PivotCell - Represents a cell in a PivotTable report.