enter value in a cell from a combo box

[Aniuska]

How to build a combo box to be able to select a value and enter in the cell

 

[Jason Morin]

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

 

[Dave Peterson]

Another option that looks very similar is Data|Validation.

See Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html