 |
 | 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 2007Context Sensitive Drop Down Menus
I need to be able to specify drop down menus that depend on the selections made in other menus. For example, I will specify in cell A1 the choice between dog and tree. If the user picks dog then I want the selections in cell B1 to be beagle and hound. If the user picks tree in A1 then I want the choices in B1 to be oak and pine. I think you get my drift. It isn't clear to me how to set this up. Any help would be appreciated. Thanks in advance. You're describing Dependent Lists. See Debra Dalgleish's coverage of them at her website: http://www.contextures.com/xlDataVal02.html Does that help? (Post back with more questions.) *********** Regards, Ron XL2002, WinXP > I need to be able to specify drop down menus that depend on the selections > made in other menus. For example, I will specify in cell A1 the choice [quoted text clipped - 3 lines] > clear to me how to set this up. Any help would be appreciated. Thanks in > advance. Thanks, Ron. Just what I was looking for. > You're describing Dependent Lists. > [quoted text clipped - 20 lines] >> in >> advance.
|
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.