Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pull downs and variables
I wish to have a pull down menu containing 15 choices each of which would cause a given groups of cells to display a list of pre-arranged text. Ex: choose "A" from pulldown in (C2); and (D16) through (D35) would display a custom list.... but if you choose "B" from the pulldown, a seperate list would appear instead... Any help in this would be greatly appreciated. -- darqphire ------------------------------------------------------------------------ darqphire's Profile: http://www.excelforum.com/member.php...o&userid=36660 View this thread: http://www.excelforum.com/showthread...hreadid=564067 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pull downs and variables
Hi
Take a look at Debra Dalgleish's site for help on this topic http://www.contextures.com/xlDataVal02.html -- Regards Roger Govier "darqphire" wrote in message ... I wish to have a pull down menu containing 15 choices each of which would cause a given groups of cells to display a list of pre-arranged text. Ex: choose "A" from pulldown in (C2); and (D16) through (D35) would display a custom list.... but if you choose "B" from the pulldown, a seperate list would appear instead... Any help in this would be greatly appreciated. -- darqphire ------------------------------------------------------------------------ darqphire's Profile: http://www.excelforum.com/member.php...o&userid=36660 View this thread: http://www.excelforum.com/showthread...hreadid=564067 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pull downs and variables
The way to do this is as follows
The lists to use in D16:D35 should be entered as list in separate ranges, and all named using a naming convention, such as List1, List2, List3, or say ListEurope,ListAsia, ListAFrica, etc., where the 1,2,3 or Europe, Asia, Africa are the values that will be selectable in the C2 list. Then in DV in D16:D35, set the DV to an allow type of 'List', and use a formula of =INDIRECT("List"&C2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "darqphire" wrote in message ... I wish to have a pull down menu containing 15 choices each of which would cause a given groups of cells to display a list of pre-arranged text. Ex: choose "A" from pulldown in (C2); and (D16) through (D35) would display a custom list.... but if you choose "B" from the pulldown, a seperate list would appear instead... Any help in this would be greatly appreciated. -- darqphire ------------------------------------------------------------------------ darqphire's Profile: http://www.excelforum.com/member.php...o&userid=36660 View this thread: http://www.excelforum.com/showthread...hreadid=564067 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|