Greetings,
I'm using excel2013
I'm using below code to select one specific item from the slicer (Slicer_Naam) this depends on the input from a dropdown list. (There's +600 options, that's why I want to use the dropdownlist with autoadding to be much quicker than the slicers) - If I understand the code right (I adjusted pieces from stuff I found online, I never learned how to code properly) it selects all options in the slicer menu en then checks them one by one untill it has a match with the values in the dropdownlist. Because there's over 600+ options this process takes +- 3 minutes. quite a hassle, because I would like to make a dashboard out of it.
My question:
Is there any way to fasten up the code? I searched the web, to try to find some code that makes the slices select the option based on a cell value (their all using letters, not numerical - they're names) but I couldn't find a solution without using loops.
Happy Easter!
Kind regards
Barowan
Bookmarks