Share via

CubeField.HasMemberProperties Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  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.<strong>HasMemberProperties</strong> = True Then
    MsgBox "There are member properties to be displayed."
Else
    MsgBox "There are no member properties to be displayed."
End If



End Sub

See Also