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)
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.