Modifying Combo Box

[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

 

[Sabine]

Have you checked that it isn't validation? Tools / Validation ....

Sabine

 

[Dave Peterson]

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.

 

[Kelvin]

Thanks to both of you. Data validation is something I've never used before.
Thanks for the help.

Kelvin