Selecting a specific item from Dropdown in excel vba

Vote count:

0

I'm working out a dashboard for my office. It all works, but I wanted to add in an option that instead of searching through 250+ items in a dropdown, you could also click on a cell and the dropdown would change to that value, and the assigned macro would run for that dropdown. So far I can't figure out how to have vba select a specific item from a dropdown. I can have the text change, but that doesn't select the index of the dropdown.

Any suggestions?

Cheers, Dave

asked 3 mins ago

jDave1984

16