Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dropdown boxes (box 1 result = box 2
I'm trying to use a dropdown box that after choosing will create choices for
dropdown box 2. box 1: 1 2 3 box 2: 1 orange 1 blue 1 green 2 yellow 2 purple 2 black 3 etc etc etc Any idea? thanks in advance, greg |
#2
|
|||
|
|||
Hi
Have a look he http://www.contextures.com/xlDataVal02.html -- Andy. "Greg" wrote in message ... I'm trying to use a dropdown box that after choosing will create choices for dropdown box 2. box 1: 1 2 3 box 2: 1 orange 1 blue 1 green 2 yellow 2 purple 2 black 3 etc etc etc Any idea? thanks in advance, greg |
#3
|
|||
|
|||
Hi Greg
Create named lists of the vairous drop-downs you want. Do a data validation, and in the Source, do ifs =if($A$1="XXX",LIST1,if($A$1=YYY,LIST2,ERROR)) etc Cheers Louis "Greg" wrote: I'm trying to use a dropdown box that after choosing will create choices for dropdown box 2. box 1: 1 2 3 box 2: 1 orange 1 blue 1 green 2 yellow 2 purple 2 black 3 etc etc etc Any idea? thanks in advance, greg |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown boxes (box 1 result = box 2
Solution given in "http://www.contextures.com/xlDataVal02.html " worked...
but If I select "1" then obviously list would display orange,blue & green... here if assume that I select blue. After that when I select "2" list gets updated for yellow, purple & black but cell still displays Blue (earlier selection)... I don't want this I want after selecting 2 the other list should display default value or blank... but certainly not the earlier selection... how can i do this?? Thanks Milind "Louis Pretorius (Johannesurg, RSA)" wrote: Hi Greg Create named lists of the vairous drop-downs you want. Do a data validation, and in the Source, do ifs =if($A$1="XXX",LIST1,if($A$1=YYY,LIST2,ERROR)) etc Cheers Louis "Greg" wrote: I'm trying to use a dropdown box that after choosing will create choices for dropdown box 2. box 1: 1 2 3 box 2: 1 orange 1 blue 1 green 2 yellow 2 purple 2 black 3 etc etc etc Any idea? thanks in advance, greg |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropdown boxes (box 1 result = box 2
Hi,
You may use the macro from here. http://www.excelforum.com/excel-prog...ther-cell.html -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Milind Keer" wrote in message ... Solution given in "http://www.contextures.com/xlDataVal02.html " worked... but If I select "1" then obviously list would display orange,blue & green... here if assume that I select blue. After that when I select "2" list gets updated for yellow, purple & black but cell still displays Blue (earlier selection)... I don't want this I want after selecting 2 the other list should display default value or blank... but certainly not the earlier selection... how can i do this?? Thanks Milind "Louis Pretorius (Johannesurg, RSA)" wrote: Hi Greg Create named lists of the vairous drop-downs you want. Do a data validation, and in the Source, do ifs =if($A$1="XXX",LIST1,if($A$1=YYY,LIST2,ERROR)) etc Cheers Louis "Greg" wrote: I'm trying to use a dropdown box that after choosing will create choices for dropdown box 2. box 1: 1 2 3 box 2: 1 orange 1 blue 1 green 2 yellow 2 purple 2 black 3 etc etc etc Any idea? thanks in advance, greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |