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

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