Edit

Share via

CubeField.HasMemberProperties property (Excel)

  • Article

Returns True when there are member properties specified to be displayed for the cube field. Read-only Boolean.

Syntax

expression.HasMemberProperties

expression A variable that represents a CubeField object.

Example

The example determines if there are member properties to be displayed for the cube field and notifies the user. The example assumes that a PivotTable exists on the active worksheet.

Sub UseHasMemberProperties() 
 
 Dim pvtTable As PivotTable 
 Dim cbeField As CubeField 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 Set cbeField = pvtTable.CubeFields("[Country]") 
 
 ' Determine if there are member properties to be displayed. 
 If cbeField.HasMemberProperties = True Then 
 MsgBox "There are member properties to be displayed." 
 Else 
 MsgBox "There are no member properties to be displayed." 
 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.