Adding a Combo Box
You can add a combo box control to a worksheet to provide more control for analysis in a DSS. This control creates a text box and button that displays a drop-down list with options that can be selected.
Begin by putting the options in a columnar range. Then click on the Combo Box on the Forms toolbar. Use the mouse pointer to size and place the Combo Box. Right click on the Combo Box to bring up a menu and go to Control Properties.
Specify the Input range and the Cell Link.