Hello all. I'm in the process of creating a dashboard for a Power Pivot data model I have put together. One portion includes multiple Pivot Tables that are all filtered using one slicer. This slicer will eventually have hundreds if not thousands of items in it, so navigating it will be difficult considering there are no search functions built into slicers, as I am now aware after browsing these forums.

So, what I would like to do is use VBA code that will prompt the user with an input box asking for a value from the slicer, which after they provide the value and click OK, it will find that value in the slicer and select it. I have tried similar solutions from users here and elsewhere but none of them seem to work after my modifications.

Maybe this isn't the proper solution either. I'm slowly becoming an Excel power user, but my VBA knowledge is like the first year of a foreign language in high school. Other suggestions are welcome.

Any help would be greatly appreciated. Thank you!