Share via

CubeField.ShowInFieldList Property

  • Article
Excel Developer Reference

When set to True (default), a CubeField object will be shown in the field list. Read/write Boolean.

Syntax

expression.ShowInFieldList

expression   A variable that represents a CubeField object.

Example

In this example, Microsoft Excel determines if a CubeField object can be shown in the Field list and notifies the user. This example assumes a PivotTable report exists on the active worksheet and a CubeField object exists.

Visual Basic for Applications 
  Sub IsCubeFieldInList()

Dim pvtTable As PivotTable
Dim cbeField As CubeField

Set pvtTable = ActiveSheet.PivotTables(1)
Set cbeField = pvtTable.CubeFields("[Country]")

' Determine if a CubeField can be seen.
If cbeField.<strong class="bterm">ShowInFieldList</strong> = True Then
    MsgBox "The CubeField object can be seen in the field list."
Else
    MsgBox "The CubeField object cannot be seen in the field list."
End If



End Sub

See Also