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.

"addy" wrote:

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

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

"Barb Reinhardt" wrote:

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.

"addy" wrote:

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

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


"Barb Reinhardt" wrote:

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.

"addy" wrote:

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

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.

"addy" wrote:

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

"Barb Reinhardt" wrote:

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.

"addy" wrote:

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"addy" wrote in message ...
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

Sorry, wrong thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
See Bob's site
http://www.xldynamic.com/source/xld.xlFAQ0005.html

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"addy" wrote in message ...
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