Modifying Combo Box

  • Thread starter Thread starter Kelvin
  • Start date Start date
K

Kelvin

I inherited an excel file that has combo boxes on it. However, I cannot
edit the contents of the box. No matter what I do, I do not get the
properties option for the box, so I can't change anything. I do not think
this is a standard excel combo box. Does anyone know of another type of
combo box outside of the standard form version and the ActiveX version.
Thanks.

Kelvin
 
If it's not data|validation, then maybe it's a combobox (aka dropdown) from the
forms toolbar.

Right click on it and select Format Control to see some of the options you can
change.
 
Thanks to both of you. Data validation is something I've never used before.
Thanks for the help.

Kelvin
 
Back
Top