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.
To use a ValueChange class variable it first needs to be instantiated, for example
Dim strTuple As String: strTuple = Dim dblValue As Double: dblValue = Dim ptc As PivotTableChangeList: Set ptc = Dim vlc As ValueChange Set vlc = ptc.Add(Tuple:=strTuple, Value:=dblValue)
Here is an example of processing the ValueChange items in a collection.
Dim pvt As PivotTable: Set pvt = Dim vlcChangeList As ValueChange For Each vlcChangeList In pvt.ChangeList Next vlcChangeList
The following procedures in this class have been grouped together and are described on a separate theme page
These are the main methods of the ValueChange class
PivotTableChangeList.Add - Adds a ValueChange object to the specified PivotTableChangeList collection.
Delete - Deletes the specified ValueChange object from the PivotTableChangeList collection.
PivotTableChangeList.Count returns a Long value that represents the number of objects in the collection.
PivotTableChangeList.Item returns a single ValueChange object from the specified PivotTableChangeList collection.
PivotTableChangeList.Parent returns the parent PivotTable object for the specified PivotTableChangeList collection. Read-only.
AllocationMethod returns the method to use to allocate this value 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.
Parent returns the parent object for the specified object. Read-only.
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.
VisibleInPivotTable returns whether the cell (tuple) is currently visible in the PivotTable report.