Edit

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.

Syntax

expression.ActiveItem

expression A variable that represents a Slicer object.

Return value

SlicerItem

Remarks

The ActiveItem property returns 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 returns 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 by 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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.