Combo Box Step by step

R

Richard Larrabee

Hi.
I am having some trouble completing the combo box in Excel
2000 Pro. The range I selected inserts numbers instead of
the selected names? Can some one e-mail me a sample that
works?

Thanks
Rich
 
G

Greg Koppel

Right click on the combobox and choose Format Control, go to the Control
tab. The input range is the list that you want to populate the box. Click on
the icon at the end of the text box and you can select the range with your
mouse. The cell link is the cell (if you choose a range with more than one
cell it only fills the first cell in the range) that you want to display the
choice made in the combobox, it displays a number corresponding to the
position of the selection in the list.

HTH, Greg
 
Top