Web Development

Ask something
Discussion Locked

Excel Combo Box

0 helpful
3 replies

by shield509

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have designed a Purchase Order using Excel 2000. The form contains a combo box with five selections listed. When I protect the Form the combo box will not allow me to select the item I wish to post to the form. I have reviewed the Protection Lock for each of the cells in the form and have locked the cells that are required to be locked. I have unchecked the locked Combo Box so that it is unlocked but I can not select the item. If I leave the form unprotected I can use the Combo Box without a problem. Any assistance would be appreciated.

3 replies

by kees.valkenswaard

There are three ways to design some sort of combo box. Therefore I do not know which one you used.
Data validation with a list is probably the simplest one, although not known and used by many people. If you want to use the list items from a range use the = sign as start of the reference.
The other types are the form control and the active-X control. Both use normally a range with the list items. Another important feature is the linked cell. The linked cell contains a number for the form combo box and the same value [text e.g.] for the choice in the active-X box. The linked cell should also be unprotected!!!
The form box has indeed to be unprotected as well. The active-X one has again different rules, just to keep it simple.
Good luck.

This discussion is closed to new replies.