Collect Pivot table's selected labels

Hi,
I have a pivot table with slicers. I would like to collect into a cell all the item names that have been selected (filtered). (through VBA or Formula)
For example if I select A, D, and E into the (A, B, C, D, E, F) list. I want the labels A, D, E to appear in a cell.
Is there a way?
Thanks!

Cross posted: http://www.ozgrid.com/forum/showthre...481#post702481
http://www.mrexcel.com/forum/excel-q...ml#post3718755
http://www.excelguru.ca/forums/newth...postthread&f=9

I came up with this and it did the trick

Please Login or Register  to view this content.