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