AutoComplete Dropdown list on Multiple cells

[HAARLEEN]

First I started by using data validation and adding a list to more than 5000 cells, but the list contains a lot of values so scrolling through it got difficult each time selecting from the list takes a lot of time. So I read many forums and used Combobox instead to autocomplete what we typed and this saved my time a lot, but the problem now is I want it to be used on all the rows in One column, I cannot copy and paste the combobo each time on every cells. is there any short cut by using VBA or anything. Kindly help me with the same it's urgent.

 

[Marc L]

Wild cross-posting + "urgent" !​

​

First read this then see the forum rules below …​

​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[HAARLEEN]

Please find the link to my post of the other site - https://www.excelforum.com/excel-pr...auto-complete-text-from-list.html#post5159231 . Please let me know if this is the correct way to do this. I am new to this so wasn't sure how this works! thanks for letting me know

 

[Marc L]

Yes all is fine now … And it seems you already have a solution on another forum or am I wrong ?​

​