Get / Search Selected Pivot Items

Hi Everyone

This forum has a way of making me feel like anything is possible, but I might be reaching too far this time

Is there any way (using VBA) to get a list of selected pivot filter items only?

I need to be able to check if the user has selected any pivot items LIKE '%HAQ%' in the following 3 pivot fields.

Or perhaps a list isn't even necessary. Can the selected pivot items be searched for any containing 'HAQ' then produce and TRUE/FALSE result?

Tables filtered by:

Please Login or Register  to view this content.

Any help greatly appreciated
All the best
V

Hi Andy

This is brilliant, it helped me to discover what was going on with the TRUE/FALSE results for the other filters also
(different results depending on whether 'Select Multiple Items' is checked)

Really helpful
Thank you
V