Forum Discussion
ladyfairfax6203
May 27, 2021Copper Contributor
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...
- May 30, 2021
See the attached version. I simplified the code.
ladyfairfax6203
May 30, 2021Copper Contributor
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
HansVogelaar
May 30, 2021MVP
See the attached version. I simplified the code.
- ladyfairfax6203May 30, 2021Copper ContributorWow - 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!