Scroll bar in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
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.
 
Back
Top