Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dependent drop down list
I know that you can create a list (i.e. Produce - Fruits, Vegetables, etc.)
and then a dependent list (i.e. Fruits -Apples, Oranges, etc.). But you have to use two columns. For example, column A is data validated for the Produce list and you choose Fruit. Then column B is data validated for the dependent lists where you can choose Apple. Is there anyway to do this without the use of column B and have everything on column A? So basically, in column A, you would put your cursor over Fruit in the drop down list and then a second drop down list would appear to the right side of the drop down list and you can choose Apple and this would be the selection in column A. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dependent drop down list
Not the way you describe. You can use VBA programming so that after you
select Fruit in the column A cell drop-down, the cell would clear and another drop-down would be available in the same cell. You click that drop-down arrow and it would display some fruits from which you can select Apple. Does this sound like what you want? HTH Otto "yowzers" wrote in message ... I know that you can create a list (i.e. Produce - Fruits, Vegetables, etc.) and then a dependent list (i.e. Fruits -Apples, Oranges, etc.). But you have to use two columns. For example, column A is data validated for the Produce list and you choose Fruit. Then column B is data validated for the dependent lists where you can choose Apple. Is there anyway to do this without the use of column B and have everything on column A? So basically, in column A, you would put your cursor over Fruit in the drop down list and then a second drop down list would appear to the right side of the drop down list and you can choose Apple and this would be the selection in column A. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DEPENDENT DROP DOWN LIST | New Users to Excel | |||
Drop down list options dependent on cell value | Excel Discussion (Misc queries) | |||
Create a list in a drop down dependent upon another dd list in exc | Excel Discussion (Misc queries) | |||
Need to creat dependent drop down list | Excel Worksheet Functions | |||
Dependent drop-down list?? | Excel Worksheet Functions |