Share via

SlicerItem Members (Excel)

  • Article

Represents an item in a slicer.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

Caption

Returns the label text for the slicer item. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

HasData

Returns whether the slicer item contains data that matches the current manual filter state. Read-only.

Name

Returns the name of the slicer item. Read-only.

Parent

Returns the parent SlicerCache object for the slicer item. Read-only.

Selected

Returns or sets whether the slicer item is selected. Read/write.

SourceName

Returns the source name of the slicer item. Read-only.

SourceNameStandard

Returns a String that represents the PivotTable items' source name in standard English (United States) format settings. Read-only.

Value

Returns the value of the slicer item. Read-only.