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.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
has member properties hasmember hasmemberproperties hasmemberproperties property

See also: