Drop Down Boxes

[MStinson]

I am trying to implement drop down boxes into a spreadsheet. They are
not form controls as far as I know. There are two working on the
spreadsheet that I am working on now but I cant figure out how they
work. But here is a description of what I do know. The cell is normal
untill you set focus on it then it has a box to the right of it that
has a down arrow. When you click the box it drops down and presents a
list of product descriptions. I know that the list comes from another
worksheet in the work book because when you edit the contents of the
last sheet of the workbook the changes show up in the drop box on the
other sheet. I have tried everything I know to and am perplexed. Could
someone please help me.
Thanks,
Matthew

 

[Jim]

Data>Validation>Allow>List, which may be referred to by a named range, a
range of cells, or a list enetered in the window, each choice separated by a
comma.

 

[Peo Sjoblom]

Those are from data>validation>allow>list, if you select one of the cells
and in the menubar click data
and select validation, a dialogue box will open..

 

[Debra Dalgleish]

The dropdowns are created by using Data>Validation. There are some
instructions here:

http://www.contextures.com/xlDataVal01.html

 

[MStinson]

That is exactrly what I wanted. I sure apreciate your help. Amazing

MStinson