I want to crate a pull down menu based on the value from another pull down
menu. E.g.
If I select 1 from the first pull down menu then the values X,Y,Z
(corresponding value associated with 1) would be in another pull down in a
different location.

1st Pull down Values 2nd Pull down Values

1 X,Y,Z
2 A,B,C
3 E,F,G
4 O,P,Q

Debra Dalgleish has the answer

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 07:58:02 -0700, kami <(E-Mail Removed)>
wrote:

>I want to crate a pull down menu based on the value from another pull down
>menu. E.g.
>If I select 1 from the first pull down menu then the values X,Y,Z
>(corresponding value associated with 1) would be in another pull down in a
>different location.
>
>1st Pull down Values 2nd Pull down Values
>
>1 X,Y,Z
>2 A,B,C
>3 E,F,G
>4 O,P,Q
>