#1
|
|||
|
|||
Clearing Drop down list to default
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
|
#2
|
|||
|
|||
Hi,
Can you provide a copy of the file so we can see what you are working with? |
#3
|
|||
|
|||
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.
|
#4
|
||||
|
||||
What kind of dropdowns are you using and what is your existing code?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
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.
|
#6
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to import list from Excel into drop-down list into word | ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
Drop Down List Help | ksigcajun | Word | 3 | 05-09-2014 05:35 AM |
Drop down list, Can it be done??? | garethreid | Outlook | 0 | 08-09-2012 06:08 AM |
Trouble with drop down list | yessmarie | Word VBA | 1 | 05-25-2012 12:43 PM |
Drop Down List Question | beb1227 | Excel | 6 | 12-08-2011 07:26 PM |