Typing into a dropdown

[Hercules7217]

What would I use to enable typing to auto populate into a drop down? The cell isn't locked so you can start to type in it and we want to be able to start typing the chart field number so we don't have to scroll through the whole list.

Thank you.

 

[My Aswer Is This]

I do not believe you can do this with a Data Validation list.
I think you should try using a Activex Combobox.
You can do what you want I believe when using a Activex Combobox

 

[shg]

There's an add-in at https://app.box.com/shared/ono8ni9xvr that will do that, a ReadMe at https://app.box.com/shared/4qxybepxxr, and an example workbook at https://app.box.com/shared/e8dbbple34

 

[Hercules7217]

Thank you! We weren't sure if we could do it or if we would have to try and start over with the Combobox

 

[My Aswer Is This]

Thank you! We weren't sure if we could do it or if we would have to try and start over with the Combobox

So did you try the add on?
Did it work for you?
I have never used addons.

 

[Hercules7217]

I haven't been able to get any of the links to work yet. Some sites are restricted by the DoD...I work for the NYS National Guard...so am trying on my phone...lol.

 

[My Aswer Is This]

Thanks

Would like to know how this works out for you.