Edit

Share via

PivotField.IsMemberProperty property (Excel)

  • Article

Returns True when the PivotField contains member properties. Read-only Boolean.

Syntax

expression.IsMemberProperty

expression A variable that represents a PivotField object.

Remarks

This property will return a run-time error if an Online Analytical Processing (OLAP) data source is not used.

Example

This example determines if the PivotTable field contains member properties and notifies the user. It assumes that a PivotTable exists on the active worksheet and that it is connected to an OLAP data source.

Sub CheckForMembers() 
 
 Dim pvtTable As PivotTable 
 Dim pvtField As PivotField 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 Set pvtField = pvtTable.PivotFields(1) 
 
 ' Determine if member properties exist and notify user. 
 If pvtField.IsMemberProperty = True Then 
 MsgBox "The PivotField contains member properties." 
 Else 
 MsgBox "The PivotField does not contain member properties." 
 End If 
 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.