Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down menu IF statement help Please
Hello everyone I am pretty new to excel and i am working on a project.
Basically what i am looking to do is lets say i have one drop down menu with 12 options. (i.e. 1,2,3,4,5....) Now what i want it to do is if i select 1, i would like another drop down menu to appear a few cells lower then the first one with different options, if i select 4 i would like 4 drop down menus to appear below it and so on. If there is anything you guys can help me out with it would be greatly appreciated! Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down menu IF statement help Please
This would take some clever VBA programming!
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Daunt" wrote in message ... Hello everyone I am pretty new to excel and i am working on a project. Basically what i am looking to do is lets say i have one drop down menu with 12 options. (i.e. 1,2,3,4,5....) Now what i want it to do is if i select 1, i would like another drop down menu to appear a few cells lower then the first one with different options, if i select 4 i would like 4 drop down menus to appear below it and so on. If there is anything you guys can help me out with it would be greatly appreciated! Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop down menu IF statement help Please
Ahh no problem I will try and find another way around it thanks for the quick
response -Daunt "Bernard Liengme" wrote: This would take some clever VBA programming! best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Daunt" wrote in message ... Hello everyone I am pretty new to excel and i am working on a project. Basically what i am looking to do is lets say i have one drop down menu with 12 options. (i.e. 1,2,3,4,5....) Now what i want it to do is if i select 1, i would like another drop down menu to appear a few cells lower then the first one with different options, if i select 4 i would like 4 drop down menus to appear below it and so on. If there is anything you guys can help me out with it would be greatly appreciated! Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Excel Script for Drop Down Menu | Excel Discussion (Misc queries) | |||
If Statement-selecting from a drop down menu?? | Excel Discussion (Misc queries) | |||
How do you create a drop down menu in excel? | Excel Worksheet Functions |