May 27 2021 07:44 AM
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.
May 27 2021 07:56 AM
If you attach a copy of your workbook, someone may be able to help you.
May 30 2021 02:15 PM
@Hans Vogelaar 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
May 30 2021 02:22 PM
May 30 2021 03:28 PM
SolutionSee the attached version. I simplified the code.
May 30 2021 03:36 PM
May 30 2021 03:28 PM
Solution