Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop list affected by previous choice
Hello,
I am using Excel 2004 for Mac and need help on drop lists. I want to change the drop list depending on the previous choice. Lets say in the first list I give the choice between 3 options (jumper, pigtail or duplex). Depending on the choice taken, there would be another drop list that will vary. For the jumper I have options A, B or C. For the pigtail I have options D, E or F and for the duplex, I have options G, H or J. Can someone help me on this issue? Thanks, Gaetan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop list affected by previous choice
I don't use a Mac, but if you've created the drop downs via data|Validation,
take a look at Debra Dalgleish's site: http://www.contextures.com/xlDataVal02.html She has some tips for working with Data|Validation and dependent lists. Gaëtan Mongeon wrote: Hello, I am using Excel 2004 for Mac and need help on drop lists. I want to change the drop list depending on the previous choice. Lets say in the first list I give the choice between 3 options (jumper, pigtail or duplex). Depending on the choice taken, there would be another drop list that will vary. For the jumper I have options A, B or C. For the pigtail I have options D, E or F and for the duplex, I have options G, H or J. Can someone help me on this issue? Thanks, Gaetan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
produce list automatically from choice of drop down list | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
drop-down list changing according to choice made | Excel Worksheet Functions | |||
How do i create a multiple choice drop down list | Charts and Charting in Excel | |||
Drop list affected by previous choice | Excel Worksheet Functions |