Searchable drop down lists without Combobox

[LostinVA]

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.

 

[dmt32]

Hi,
Contextures site always worth a visit - they have number of example files that you can download for free

Here is one example that may do what you want

DV0023 - Limit Selection List -- If you have a lengthy list, it's hard to find an item in the data validation dropdown. Use an Advanced Filter to create a short list, and select from that. Event code creates the short list. DataValSelectName.zip

Dave