Combo Box Referencing and Assignment

Hi:

I would like to create a drop down box for a cell so that the user can
select one of the values listed. How can I do this?

I am not familiar with how to do other than by using a combo box. That being
the case, how would I associated item, selected, in a combo box to a specific
cell? How do I reference combo box items and assign them to a cell?

Thank you all,

Ed.

You may find Data|Validation easier to implement.

Debra Dalgleish has some nice instructions for you:
http://www.contextures.com/xlDataVal01.html

Edd wrote:
>
> Hi:
>
> I would like to create a drop down box for a cell so that the user can
> select one of the values listed. How can I do this?
>
> I am not familiar with how to do other than by using a combo box. That being
> the case, how would I associated item, selected, in a combo box to a specific
> cell? How do I reference combo box items and assign them to a cell?
>
> Thank you all,
>
> Ed.

--

Dave Peterson