Forum Discussion
Solved
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 autocomp...
See the attached version. I simplified the code.
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.
- Wow - thank you - this has been driving me nuts - and apparently I am not the only one out there who uses excel for a lot of things but doesn't write code and gets stumped when something so basic isn't built into program. Microsoft ought to pay you the big bucks!