Excel 97: ComboBox - how to deselect item

  • Thread starter Thread starter David
  • Start date Start date
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.
 
Back
Top