Userform combobox dropdown question

  • Thread starter Thread starter teepee
  • Start date Start date
T

teepee

Hello

Forgive my ignorance but I've looked everywhere for an answer to this
question.

Does anyone know how to get a dropdown on a userform combobox to deactivate
via VBA (ie retract itself and deselect itself, but still show the
combobox?)

In other words, what command does the opposite of ComboBox1.DropDown

I tried ComboBox1.DropDown = false

and

Shapes("Drop Down 1").Select
Selection.Delete

but neither did the trick. I'd be so grateful if anyone knew of a solution
or could confirm there is no solution

Best

tp
 
I have the same problem. I cannot use the enabled = false then enabled = true trick because my code wont let the combobox lose focus and you cant disable a focused controll. It would be great if it were bossible to retract acombo box without dropping the control's focus.
 
Back
Top