 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Scroll 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 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. > 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 > 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 [quoted text clipped - 6 lines] > > > > 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. > 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, [quoted text clipped - 12 lines] > > > > > > Many thanks Its worked!! I was doing it wrong. Many thanks for all your help > 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 [quoted text clipped - 6 lines] > > > > Many thanks See Bob's site http://www.xldynamic.com/source/xld.xlFAQ0005.html  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm >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 SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > See Bob's site > http://www.xldynamic.com/source/xld.xlFAQ0005.html [quoted text clipped - 5 lines] >> >> Many thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.