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

Here's a method

http://www.contextures.com/xlDataVal02.html

--
Regards,

Peo Sjoblom

(No private emails please)


"Ga ë tan Mongeon" wrote in message
...
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

Thank you

On 6/25/05 3:13 PM, in article , "Peo
Sjoblom" wrote:

Here's a method

http://www.contextures.com/xlDataVal02.html