Is it possible to add a search box to dropdown menue?

[yabi100]

I made a data validation to my data entry to cells. The list is very long. I want to know, is it possible to add a search box to it? I know I can type the first letter of the entry and selection will go to the first appearance of that letter. , but the word I am looking for, is not the starting word. What I thought as a solution, is to add a search box, but if there is another way, let me know.

 

[Fluff]

You could use a combobox rather than data validation. Create an Excel Drop Down List with Search Suggestions

 

[Akuini]

If you're willing to use an add-in, you can try a free Excel add-in called "Search deList" to get searchable data validation. You can find it here:

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com