PivotField.IsMemberProperty Property

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.<strong class="bterm">IsMemberProperty</strong> = True Then
    MsgBox "The PivotField contains member properties."
Else
    MsgBox "The PivotField does not contain member properties."
End If

End Sub

See Also

• PivotField Object
• PivotField Object Members