Finding Our Selected Slicer Value

Something like below.

Please Login or Register  to view this content.

It's not a basic question

There is no Event handler that captures Slicer item selection. If the slicer was for PivotTable, you'd be able to use PivotTable_Update event to trigger the code.
There is Worksheet_TableUpdate event as well. However, since slicer does not update tables, this can't be used.

Workaround is to set up some out of way cell with following formula (I used cell K1)
=SUBTOTAL(3,Table1[ColumnName])=COUNTA(Table1[ColumnName])

It will return True when all items are visible (i.e. selected) and returns false otherwise.

Then you can use Worksheet_Calculate event like below.

Please Login or Register  to view this content.