enter value in a cell from a combo box
 

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

-----Original Message-----
How to build a combo box to be able to select a value
and enter in the cell
.

Another option that looks very similar is Data|Validation.

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

Aniuska wrote:

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

--

Dave Peterson