Using a Combo Box Control

To insert a combo box form control, use the following procedure.

1. Select the Developer tab.
2. Select Insert. Select Combo Box Form from the drop down list.
3. Click and drag the mouse to draw the combo box.

4. Right-click the combo box, and select Format Control from the drop down list.

5. In the Input range field, enter or select cells H1:H20.

6. The Cell link field will put a number value in the linked cell. We’ll do this so our INDEX formula (which references cell G1) in cell A1 will return the list box choice. Enter or select G1 for the Cell link field.

7. The Drop down lines indicates the number of lines that show in the list at one time.
8. Select OK.
9. Now click anywhere besides the combo box to deselect it. When you select the arrow and choose an item from the list, the INDEX formula in cell A1 uses the selection to display the item’s name.