I have a drop down list in an application that contains values from some hidden cells. When I created it, Excel named it "Drop Down 91" which is fine. Once someone fills out the form and clicks a "Submit" button to write the values to a different sheet, I clear our the values they typed in for their name, address, etc.
However, I can't figure out how to reset the drop down list to its first value (which happens to say "Select One..." and is cell Q1. Any idea how to write that macro?
Bookmarks