Setting defaults as blank for dropdowns in Excel

[mattpearcey]

I have made up a questionnaire in excel using various dropdowns and option boxes. I have used one sheet as the display form, one as the data form (to hold all the options for the dropdowns), and the last sheet as the results sheet. I want to send this out to a number of people, but where i have tested it, the answers are still in the boxes on the display form. Is there a way that i can reset these? The only way i can figure is if i go to the results worksheet and manually delete all the answers that i have put in there?

Any ideas? Thank you for your help already.

Matt Pearcey

 

[JVFriederick]

I think deleting each is your only option.

However, writing a macro to reset all pulldowns in the future may be a worthwhile investment.

 

[mattpearcey]

I think the delete option is the best. I only need to do it once, then save and use that as the main doc, so its not too much of a hassle. Thanks for the help. Thank you for your help already.

Matt Pearcey