ShowPageMultipleItemLabel Property

Microsoft Excel Visual Basic

expression.ShowPageMultipleItemLabel

expression    Required. An expression that returns a PivotTable object.

Example

This example determines if "(Multiple Items)" will be displayed in the PivotTable cell and notifies the user. The example assumes that a PivotTable exists on the active worksheet.

Sub UseShowPageMultipleItemLabel()

    Dim pvtTable As PivotTable

    Set pvtTable = ActiveSheet.PivotTables(1)

    ' Determine if multiple items are allowed.
    If pvtTable.ShowPageMultipleItemLabel = True Then
        MsgBox "The words 'Multiple Items' can be displayed."
    Else
        MsgBox "The words 'Multiple Items' cannot be displayed."
    End If

End Sub