enter value in a cell from a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to build a combo box to be able to select a value and enter in the cell
 
1. Go to View > Toolbars > Control Toolbox
2. Click on the "Combobox" icon once and draw one on your
worksheet (hold down the ALT button to fit to a cell).
3. Right-click on the Combobox and go to Properties.
4. In the ListFillRange type in the range of cells that
contain the values to fill the combobox, like A1:A5.
5. In the LinkedCell field type a cell reference that
will contain the user's selection (ie E2).
6. Click on the Exit Design Mode icon and close the
toolbar.

HTH
Jason
Atlanta, GA
 
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

Combo box value does not update in Excel 2007 4
Add a combo box 1
combo boxes 1
combo box 2
Insert combo box in a cell 3
Using text answer in a combo box in an @IF statement elsewhere 5
Access Control on subform / combo box requesting parameter 0
display list selection in a different cell 2

Back
Top