VBA code to print slicer selections back into worksheet

Hi,

I am currently using a slicer to filter a table on my worksheet.

My objective is to capture the slicer selections for each item in the slicer and print the slicer item and selection value (true/false) into separate cells using VBA.

For example, I would want the output to look like this:

SlicerItem1 TRUE
SlicerItem2 FALSE
SlicerItem3 TRUE



I know I can probably use the below code to iterate through the slicer - but I don't know how to print the slicer selection values back into the worksheet in the above format:

Please Login or Register  to view this content.

Will be very grateful for any help!Example_Workbook.xlsx