Thread: Clear Combobox from forms toolbar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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


Reply With QuoteReply With Quote