View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BrucenAZ BrucenAZ is offline
external usenet poster
 
Posts: 5
Default Using an Excel macro to reset a drop down list

How do I reset a drop down list to a default, such as "Choose answer," using
a macro. I tried recording it straight forward, but no luck.

I'd like the macro to 1) clear the name field (this is a quiz), 2) reset the
score to zero and 3) reset the drop down answers for each question to "choose
answer." I already have #1 and #2 figured out. Thanks.