Skip to content

Latest commit

 

History

History
45 lines (25 loc) · 1.35 KB

Excel.Slicer.ActiveItem.md

File metadata and controls

45 lines (25 loc) · 1.35 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Slicer.ActiveItem property (Excel)
vbaxl10.chm905092
vbaxl10.chm905092
Excel.Slicer.ActiveItem
ecf95cb2-fb1e-97fc-46a1-2ddcf784a089
05/16/2019
medium

Slicer.ActiveItem property (Excel)

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.

[!includeSupport and feedback]