Reset Combo Box back to Null
 

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!

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!