CubeField.HasMemberProperties Property (Excel)
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 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