Excel.CubeField.ShowInFieldList.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
CubeField.ShowInFieldList property (Excel)	vbaxl10.chm668092	vbaxl10.chm668092	Excel.CubeField.ShowInFieldList	9a9163f3-b398-5059-9dce-b993413e850b	04/23/2019	medium

CubeField.ShowInFieldList property (Excel)

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 that a PivotTable report exists on the active worksheet and that a CubeField object exists.

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.ShowInFieldList = 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

[!includeSupport and feedback]