Dave,

Did you solve this? I have the exact same question so if you have a
solution, please let me know.

Regards
Mitch

"Dave" skrev:

How do I set default values in a drop down list. I currently have a macro
which resets the sheet (resets the order number and customer cell for
example) but the options of the drop down menu cannot be reset this way. Can
anyone help?