 |
 | 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 / May 2008dropdown list determined by another dropdown list
I am trying to creat an ordering form that has several criteria/options that have to be matched to allow other options. I have a dropdown box that allows 4 options (1,2,3 or 4) and depending upon which one is selected then nedd box needs to only show the next options according the that number. Dropdown box One > Option 1 Dropdown box Two > Option A or B Dropdown box One > Option 2 Dropdown box Two > Option C or D Dropdown box One > Option 3 Dropdown box Two > Option E F or G etc I've setup the lists in another sheet in the workbook and have them named but cannot work out how to link the 2 boxes/lists together. Many thanks Take a look at Debra Dalgleish's site here: http://www.contextures.com/xlDataVal02.html where she shows how to set up dependent lists. Hope this helps. Pete On May 19, 4:08 pm, Wackyracer <Wackyra...@discussions.microsoft.com> wrote: > I am trying to creat an ordering form that has several criteria/options that > have to be matched to allow other options. [quoted text clipped - 16 lines] > > Many thanks Thanks very much. Exactly what I needed. > Take a look at Debra Dalgleish's site here: > [quoted text clipped - 28 lines] > > > > Many thanks You're welcome - thanks for feeding back. Pete On May 19, 4:41 pm, Wackyracer <Wackyra...@discussions.microsoft.com> wrote: > Thanks very much. Exactly what I needed. the below link is very helpful for this. It's really difficlut to hass these out on a board www.xldynamic.com/source/xld.dropdowns.html Jeremy > I am trying to creat an ordering form that has several criteria/options that > have to be matched to allow other options. [quoted text clipped - 16 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.