Excel.PivotField.IsMemberProperty.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotField.IsMemberProperty property (Excel)	vbaxl10.chm240131	vbaxl10.chm240131	Excel.PivotField.IsMemberProperty	e24e6e84-2c27-5d33-78c4-b48e96d48e5d	05/04/2019	medium

PivotField.IsMemberProperty property (Excel)

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

[!includeSupport and feedback]