Clear Combobox from forms toolbar
 

i have a combobox set up from the forms toolbar

what i want is a macro to clear the combobox or reset it

can this be done.

the actual name of the combobox is dropdown117

Clear Combobox from forms toolbar
 

ActiveWorksheet.DropDowns("Drop Down 117").ListIndex = 0

Change Drop Down 117 to the actual name of the dropdown (they usually
contain this spacing, but yours may not).
--
Regards,
Tom Ogilvy


"Pete" wrote in message
...
i have a combobox set up from the forms toolbar

what i want is a macro to clear the combobox or reset it

can this be done.

the actual name of the combobox is dropdown117