Excel 97: ComboBox - how to deselect item

D

David

I would like to be able to deselect the item of a
combobox. Upon a certain event I would like a combobox to
be restored to its initial state, in that it has no
selected item.

I've tried to use the following but they all result in
an "Invalid Property" error message:
Combo1.value = ""
Combo1.value = Null

The only workaround I can think of is to include a blank
value within the possible dropdown values and select it. I
really don't want to use that method though as its ugly to
have a blank row in every combobox.
 

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

Top