View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Reset Combo Box back to Null

Hi

Will this do ?
Combobox1.Listindex = -1

or perhaps
Combobox1.Text = ""

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Aaron" skrev i melding
...

I have multiple combo boxes that have source cells that are all populated.

However, I want to be able to reset all of the combo boxes back to Null (or
even " "). Manually I can double click the contents of the list box
(highlights) and then hit the delete key. How can I do this
programmatically? Recording a macro does not capture this.

Thanks in advance!