IsMemberProperty Property

Microsoft Excel Visual Basic

Show All

IsMemberProperty Property

       

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

expression.IsMemberProperty

expression   Required. An expression that returns 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