Forum Discussion
Data Form Dropdown
Hi. I created a spreadsheet that tracks equipment maintenance. I was starting to build a userform before I realized Excel had a premade form that does almost everything I need. The one problem is the excel form doesn't have dropdown options when adding new data. I added data validation so when someone tries to input an inappropriate response in the field it will give them an error; however, if they don't know exactly what they need to write it may become frustrating. Is there a way to modify the options for the excel form or will I have to learn a bit of VBA and build a userform from scratch?
In the same menu of data validation, you can create a dropdown! There's the "List" option, in which you need to insert a list (cells) from the same worksheet. I suggest you to insert that list in another sheet and then hide/protect it.
I'm sorry if I was not clear. I'm aware of how to create a dropdown list. My question was whether I could modify the excel data form (the one you have to readd from the ribbon) to include dropdowns.
