Slicer.ActiveItem Property (Excel)

  • Article

Returns a SlicerItem object that represents the slicer button that is currently in focus for the specified slicer. Read-only.

Version Information

Version Added: Excel 2010

Syntax

expression .ActiveItem

expression A variable that represents a Slicer object.

Return Value

SlicerItem

Remarks

The ActiveItem property will return a SlicerItem object when the specified slicer has focus and the active control is a button within the slicer (for example, the user can navigate the buttons within the slicer with the keyboard in this state).

The ActiveItem property will return Null under the following circumstances:

  • The specified slicer does not have focus (is not selected or active).

  • The specified slicer has focus and the whole slicer itself is selected (for example, the user can move the whole slicer around using the keyboard in this state).

  • The specified slicer has focus and the active control is the Clear Filter button in the header of the slicer.