Autocompleting data validation

[Sweedler]

Hello

I think that this has been debated and look upon before, but I would like to revisit it.

I need to enter some datavalidations lists into a few cells, but the source is so large that I would like to allow it to autocomplete. I have seen versions where FILTER allows for that, but as that is not available in anything but 365, I need another option. Would prefer not to mix in VBA in this one.

 

[Akuini]

Would prefer not to mix in VBA in this one.

See if this helps:
I created an Excel add-in for searchable data validation (with combobox) , called "Search deList".
Its function is to speed up the search in the data validation list. It works on multiple cells. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.
By using this add-in you don't need VBA to have this searchable combobox, it works on any cells that have data validation on any workbook.
I share the add-in 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