Oh. Thanks Bernie!

I didnt know it was possible to do that! It's an Awesome trick that's going to eliminate some 50 lines of code for me.

Do you also know if its possible to program a pivot table slicer so that a person cannot select more than 1 item at a time? (ie, they wouldn't be able to use the shift key or the control key and select multiple items). I can do it with an action button, but I would like to be able to do it by clicking on the slicer.

thanks!