Cear Contents in drop down box

gbaker · #1 03-25-2013, 09:11 AM

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.

macropod · #2 03-28-2013, 02:17 AM

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.

gbaker · #3 03-28-2013, 05:19 AM

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

macropod · #4 03-28-2013, 08:43 PM

Hi gay,

Try:

Code:

Dim DD As DropDown
    For Each DD In Sheets("Event Entry").DropDowns
      DD.ListIndex = 0
    Next

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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