Drop Down List

[sue]

Hi I need to create a pick list in a spreadsheet.

For example: In cell B7, I want to give the user the
option to enter: Apples, Oranges or Pears. I need to
provide them with a pick list and depending on what they
select, the answer will appear in cell B7. I am pretty
new to excel and am not sure how to tackle this. I have
looked at the Forms toolbar and used the combo box but I
am now stuck.

Please help. Thanking you in advance.
Sue

 

[Don Guillett]

Just make a list somewhere and right click on the combobox>select format
control>select control
Refer to your range list
etc

 

[Squid]

Make sure you are in design mode. Use the combo box in
the control toolbox toolbar.

Select the combo box, then Right click on the combo box
and select properties.

In the ListFillRange enter the range where your Apples,
Oranges, Pears is listed. i.e. A1:A3

In the LinkedCell enter B7. This is where the result of
the selection in the combo box will appear.


Is this what you had it mind?

 

[Dave Peterson]

You might want to take a look at Data|Validation.

I think it'll be the easiest to implement.

See Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html
for tons of info

 

[Don Guillett]

the answer will appear in cell B7

 

[Dave Peterson]

Put the list somewhere else (on another worksheet??) and make the cell with
Data|Validation B7?????

 

[Guest]

Hiya

Thank you very much. That is exactly what I needed. Many
thanks.

Sue