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?