Thread: creating a pulldown based on the value of another pulldown menu
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default creating a pulldown based on the value of another pulldown menu
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
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


Reply With QuoteReply With Quote