This tutorial will provide a VBA method to help you achieve it.Īutocomplete when typing in drop down list with VBA code If there is method for allowing to auto complete when typing the first letter in the drop down list, everything will become easier. If you have a data validation drop down list with large items, you need to scroll up and down in the list just for finding the proper one, or type the whole word into the list box directly. How to autocomplete when typing in Excel drop down list?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |