#1
|
|||
|
|||
Cear Contents in drop down box
Hello All,
I have several drop down boxes on a sheets. I created a macro to save the information from the drop down boxes. How do I clear the information chosen so the next time someone wants to enter new information the boxes will be blank but still will have the list to choose. |
#2
|
||||
|
||||
That depends on how the dropdown boxes are implement.
Can you attach a file to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Cear Contents in drop down box
Hi Macropod,
I have attached a sample of the workbook that I need to be able to clear drop down boxes after infromation is saved. Thanks in advance for your assistance. GWB |
#4
|
||||
|
||||
Hi gay,
Try: Code:
Dim DD As DropDown For Each DD In Sheets("Event Entry").DropDowns DD.ListIndex = 0 Next
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
drop down box | dockta | Word | 1 | 03-25-2013 10:12 PM |
Add a calendar drop down box | gbaker | Word | 2 | 11-21-2012 11:44 AM |
Drop down list, Can it be done??? | garethreid | Outlook | 0 | 08-09-2012 06:08 AM |
Populating ComboBox or Drop Down list with contents of a text field | Billy_McSkintos | Word VBA | 1 | 09-13-2011 05:50 AM |
Drop Down Boxes | Thomas Farmery | Word | 7 | 01-05-2011 01:58 AM |