COMBO BOX MISSING, BUT PROPERTIES EXIST

[DeanP]

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]

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

Capture.JPG

[DeanP]

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.