Searchable drop down entirely in VBA?

Don't know if this will help at all but I made something for myself aaages ago. See if it sorts you out

If somebody could help, it would be really great.

I've got an excel sheet where I wanted to apply ComboBox searchable drop-down menu on 200cells. I prefer ComboBox, because when typing a word, you can see the list shrinking and select from what's been filtered through, whereas with data validation, you have to start typing, then click the drop-down menu and if you still can't see the right name, carry on typing/ clicking/ scrolling.. What's the way to create that many ComboBoxes, so that they would all work?

Ipetkut

Welcome to Ozgrid Forum.

Please take the time to read our Forum Rules. You will get a better idea of how to post your question. You should not post in another person's Thread, start your own, put a link to another if you feel it might help.

Also, an example workbook can often help.