Reset Combo Box back to Null

A

Aaron

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

Harald Staff

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box 2
Highlight multiple items in listbox based on textbox item 1
VBA - (re-) Set a Table Style 2
"Reset" combo boxes 4
Undo a combo box selection 3
Retain combo box order 2
Reset combo box on unbound form 5
Showing combo box box that's not an option in its drop-down list 5

Top