Autocomplete dropdown list

[adambc]

I have a table with a Name column that is critical to populating the other columns from lookup tables ...

But the Name has to be a 100% match to its own lookup table ...

So I have implemented a dropdown in the Name column that will not allow manual entries and must match an entry in the Name lookup table ...

But ... there are over 200 Names and I would like to implement autocomplete to avoid users having to scroll ... and scroll ... and scroll ...

I've tried a Combo Box (ActiveX Control) but as far as I can see this only allows me to populate a predetermined cell ie I can't apply it to every row in my table (hope that makes sense?) ...

Is there any other way to implement autocomplete for a dropdown list that I've missed?

Thanks ...

 

[Akuini]

I created an add-in called “Search deList”, and I shared it as a freeware, and also the code is not protected so you can check it & amend it as needed.

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 space) in the combobox and the list will be narrowed down as you type.
You can use up-down arrow to select an item, then hit ENTER, the selected item will be inserted into the cell, and the Userform will be closed.

If you're interested, here's the link (it's an .xlam file):

Search_deList_v_1

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[Akuini]

In case you or anyone needs it, I share the “Search deList” add-in with more detailed explanation in this thread link

 

[eastrand]

I just ran across this. Maybe it will help someone.

Celia Alves on LinkedIn: #excel #windows #letscelebrate | 85 comments

HURRAY! A Long-time awaited feature in #Excel is finally here! AUTOCOMPLETE DROPDOWN LISTS in Excel for #Windows Desktop! Thank you Excel Team! AND WAIT!!!… | 85 comments on LinkedIn

www.linkedin.com