Cear Contents in drop down box

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Cear Contents in drop down box

03-28-2013, 08:43 PM

macropod

Windows 7 64bit Cear Contents in drop down box

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

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]

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 AM.