You can use ComboBox control from Control Tool Box (ViewToolbars) and set
the below properties of the controls to a cell range. The linked cell will
always have the selection value which can be used as a reference in your
formulas/macros..

ListFillRange
Linked Cell

If this post helps click Yes
---------------
Jacob Skaria


"Gail" wrote:

Is it possible, using a combo box from the Forms Control toolbox (not the
ActiveX toolbox) to allow the user to either select from the drop-down list
OR enter information into the field?