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