 |
 | 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 / General Excel Questions / November 2007Drop Down Menu Conditional Formatting
I've created a drop down menu for cell I4 that allows users to choose A, B, C or D. Depending on what letter they choose, I want another drop down menu. Such as, if they choose A, I want their choices to be Apples, Oranges, Grapes. If they choose B, I want their choices to be Grapefruit, Kiwi, Plums. And so on. How do I do that? karen, When you say "drop down menu", do you mean Data Validation? If so, this page gives instructions on how to acomplish what I think you are describing: http://www.contextures.com/xlDataVal02.html HTH, Conan > I've created a drop down menu for cell I4 that allows users to choose A, > B, C [quoted text clipped - 3 lines] > Grapes. If they choose B, I want their choices to be Grapefruit, Kiwi, > Plums. And so on. How do I do that? Yes, I mean Data Validation.....I'm actually trying to work with the contextures.com site you sent me, but I'm having a little trouble. Would you allow me to call you to get a few quick questions answered? you can email me at karensm@us.ibm.com > karen, > [quoted text clipped - 16 lines] > > Grapes. If they choose B, I want their choices to be Grapefruit, Kiwi, > > Plums. And so on. How do I do that? Check out this link... http://www.xldynamic.com/source/xld.Dropdowns.html  SignatureHTH... Jim Thomlinson > I've created a drop down menu for cell I4 that allows users to choose A, B, C > or D. Depending on what letter they choose, I want another drop down menu. > Such as, if they choose A, I want their choices to be Apples, Oranges, > Grapes. If they choose B, I want their choices to be Grapefruit, Kiwi, > Plums. And so on. How do I do that? Isn't there another way? I downloaded VBD but I cant figure out how to open it in excel and use it. And if I did figure out how to open it, it might take me weeks to learn how to use it. Is there a way to do what I'm asking within Excel itself? > Check out this link... > [quoted text clipped - 5 lines] > > Grapes. If they choose B, I want their choices to be Grapefruit, Kiwi, > > Plums. And so on. How do I do that? |
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.