• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Searchable drop-down list without VBA


New Member
Hi all -

I have a sheet with multiple columns utilizing data validation drop-downs. I need the drop-downs to be searchable due to the large number of options in the drop-down lists (Country column for example). I understand there are limitations with data validation and this can be done with Comboboxes. Unfortunately, I am unable to email Macro-Enabled workbooks so Comboboxes are a no-go. Is there some kind of workaround to solve this?

Really hoping one of you excel guru's can help!! Thanks everyone in advance.