I am working with a form that includes approx 10 - 12 drop down lists that have answers from yes, no and N/A. This form will also include a section where comments can be entered. I am trying to find a way to use a macro to clear the form. (drop down list and comments). Any suggestions

Hi,

Can you provide a copy of the file so we can see what you are working with?

At this time I can't. The file is a basic file with approx 14 sections that require a answer of yes, no or N/A. Those options are in a drop down box.

What kind of dropdowns are you using and what is your existing code?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Its your basic drop down with the responses of "Yes, No, and No". There is no other code in the form. I have attached a screen shot, regarding the drop down.

Attached Images

form drop down.jpg (21.5 KB, 12 views)

Aside from userform listboxes & comboboxes, both of which might be called dropdowns, Excel workbooks support dropdown controls, combo-box controls, ActiveX listboxes & ActiveX comboboxes. Hence, simply saying "Its your basic drop down" doesn't answer the question as to what kind of dropdowns are you using.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]