Hello,
I have a workbook with over 100 dropdown menu's on it. Almost all of the dropdowns populate the cell right next to them with data depending on what you choose.
I would like to create a button that resets all of the dropdowns to the first item in the list. I've tried a few codes I found that I thought would work, but every code seems to just "clear" the menu.. So then the values populated by the drop down menu shows "#NAME?" instead of just being blank and the menu item selected is a blank space at the bottom of my list (I want it to select a blank space I put at the top of the menu). I know there are ways to make it seem like it worked like I wanted, but I need the menus to be set back to the first item.
I also tried a few times to record a macro and manually chosing the first item in each list, but it didn't recognize my selections. Should I be able to record a macro to do this? If so, what could I be doing wrong?
Any suggestions if recording isn't an option?
Thanks!
Bookmarks