Combo Box Step by step

  • Thread starter Thread starter Richard Larrabee
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Combo Box questions 1
Combo box value does not update in Excel 2007 4
Formatting Output Range in Combo Box 2
Combo box 2
Combo box output excel 2007 2
Graph linked with combo boxes 2
Combo Box/Drop down box 1
Combo box result text not number 2

Back
Top