PDA

View Full Version : [SOLVED] COMBO BOX MISSING, BUT PROPERTIES EXIST



DeanP
12-10-2018, 01:50 PM
I had an active x combo box in my worksheet but it has somehow disappeared. When I insert a new combo box, I can see all the properties of my missing box in the View Properties Dropdown but no box anywhere.
Is there a way can recover the missing box?

Paul_Hossler
12-10-2018, 05:27 PM
Most likely, the Height and/or Width got set to 0 or a very small value

Happens sometimes when I change column width

See if you can reset them using the properties

Also make sure that it's not in a hidden column

23382

DeanP
12-10-2018, 05:45 PM
Thanks for pointing me in the right direction Paul. Height and width was not the problem - the ShowDropButtonWhen property was set to Never. As soon as I changed that all was ok.