Scroll bar in excel

[Guest]

I don't use excel that much but I want to add a scroll bar to excel with a
list of items to pick. I guess I use a scroll bar. I've manged to add a
scroll bar but can't find how to add my list. Do I have to use VBA or is it
simpler than that - can't find any help on help!!

Many thanks

 

[Guest]

Are you saying you want to be able to select something from a list in a
specific cell? If so, you want to use Data Validation. If it's something
else, come back and clarify your question.

 

[Guest]

Thanks. Looked at data validation but I don't think that's what I want. I
want a drop down list to pick from such as yes, no or excellent, good,
satisfactory, pooor etc.

Thanks

 

[Guest]

Its worked!! I was doing it wrong. Many thanks for all your help

 

[Guest]

Look at Data Validation again.
Allow LIST
Enter
yes, no, excellent, good, satisfactory, poor
As your list.

You could also have a named range with your lists in them, but that is a bit
more complex.

 

[Ron de Bruin]

See Bob's site
http://www.xldynamic.com/source/xld.xlFAQ0005.html

 

[Ron de Bruin]

Sorry, wrong thread