Reset Combo Box back to Null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi

Will this do ?
Combobox1.Listindex = -1

or perhaps
Combobox1.Text = ""

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

Aaron said:
I have multiple combo boxes that have source cells that are all populated.
Click to expand...
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.
 
Back
Top