ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform combobox dropdown question (https://www.excelbanter.com/excel-programming/389911-userform-combobox-dropdown-question.html)

teepee

Userform combobox dropdown question
 

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






All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com