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.
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.
- 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!
