ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 326
- Office Version
- 365
- Platform
- Windows
In Excel 2016. I am using a slicer from a Table simple as a list simple list selector. How can I capture the selected item text in VBA.
Example
Data
A
B
C
I would have a slicer that would list A, B and C.
I select C. How can I capture this. Slicer is called "Slicer 1"
Example
Data
A
B
C
I would have a slicer that would list A, B and C.
I select C. How can I capture this. Slicer is called "Slicer 1"