Drop Down Lists

[Adam]

I'm trying to build a drop down list into a worksheet and
am not sure how to do it, of if Excel is even capable of
doing it. The list will have around 30 entries in it,
with each entry related to a value in another cell. Can
anyone tell me how to do this?

Thanks,

Adam

 

[Jeff]

Combo Box

 

[Roger Govier]

Hi Adam

Try using Data Validation
Take a look at Debra Dalgleish's site
http://www.contextures.com/xlDataVal01.html
for a good explanation

 

[Dan E]

Adam,

For in cell dropdowns using Data Validation. Debra Dalgleish has
a good tutorial on her site.
http://www.contextures.com/xlDataVal01.html

another:
http://www.beyondtechnology.com/tips018.shtml

Out of cell use:

Combo Box (Forms Menu)
Right click and choose Format Control
Under the Control tab the Input Range is the data you want listed
in the combo box. The Cell Link is the cell you want the index of
the selected item entered in

Combo Box (Control Toolbox)
Right click and choose properties (must be in design mode)
in the ListFillRange property enter the range you want to appear in
the dropdown. In the LinkedCell enter the cell you want the
selected item to appear in.

Dan E

 

[txdiehard]

-----Original Message-----
I'm trying to build a drop down list into a worksheet and
am not sure how to do it, of if Excel is even capable of
doing it. The list will have around 30 entries in it,
with each entry related to a value in another cell. Can
anyone tell me how to do this?

Thanks,

Adam

.

from the menu pick Data, then Validation, in the allow box
select list. For the Source pick the range of cells
containing the entries.

 

[Robin]

Thanks for the tip to the contexture website. It was a great help

 

[Guest]

-----Original Message-----
Combo Box

you define for the cell wich text/words should be in a
list. You can copy it to other cels as well. In this way
you press on the errow in the cell and select the entry.
N.