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.

The main procedures of class ValueChange are PivotTableChangeList.Add and Delete


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)

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

For Each

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

Value with its procedures AllocationValue and Value


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.