Share via

PivotField.IsMemberProperty Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  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