Forum Discussion
Autocomplete in a data validation cell
Using Office 365 Excel in Win10 desktop
Made a form with a data validation column for products from a separate sheet in my workbook
Watched the Contextures.com video to make it possible to autocomplete the cell by typing in the first letter from the list of 100's of products, by adding a Combo box and the code they provide but it doesn't work.
Since probably 99% of people using a form with hundreds of items to choose from would want to have autocomplete, you would think MS would include this option the Data Validation pop-up box, but no, somehow you are suppose to figure out this mundane task by watching 100's of videos and thousands of threads that either do not apply to Office 365 or are so convoluted only a programmer could figure out.
Any help would be appreciated.
See the attached version. I simplified the code.
5 Replies
If you attach a copy of your workbook, someone may be able to help you.
- Also, I usually use Access for this type of stuff, but in this case it has to be Excel because others will need to be able use it on their phones and that's not an option with Access. Quickbooks Online is useless for this type of business, so that' why I am trying to figure this out in Excel
HansVogelaar here's the sheet with the VB code pasted in from contextures. Seems crazy that this isn't automatically an option when you create a data validation list
See the attached version. I simplified the code.
