Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default creating a pulldown based on the value of another pulldown menu

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically populate a Date pulldown menu? Arlen Excel Discussion (Misc queries) 1 July 24th 08 04:20 PM
multiple choices from pulldown... how to apply to several pulldown DianeN Excel Programming 4 February 22nd 07 03:42 PM
changing image based on pulldown Sandy Ryan Excel Programming 4 February 9th 06 07:11 PM
not clearing second pulldown Sandy Ryan Excel Programming 1 February 9th 06 06:17 PM
Pulldown Sub-menus within the main menu! aiyer[_10_] Excel Programming 1 April 7th 04 09:09 PM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"