Scroll bar in excel
 

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

Scroll bar in excel
 

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

Scroll bar in excel
 

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

Scroll bar in excel
 

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

Scroll bar in excel
 

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

Scroll bar in excel
 

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

Scroll bar in excel
 

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