Searchable drop down entirely in VBA?

  • 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.