Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Selection using Drop down/Combo boxes
Hi,
I've got a problem which is a little difficult to explain so bear with me! Firstly I'd like do have two drop down boxes which flow through each other. So Box One has 1,2 and 3 as options, for example. If Box One selects "1", Box Two would offer 1,2,3. If Box One selects "2", Box Two would offer 4,5,6 etc. Based on the final outcome in Box Two I'd like the cells to the right of Box Two to show specific information. Is this possible? I'm effectively trying to put in a scroll option for a number of Rows where only the Row currently selected can be seen, to tidy it up a bit. If anyone has any ideas on this it would be greatly appreciated. This is my first time on here and there is a wealth of info and it's a great source of learning! Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Selection using Drop down/Combo boxes
Hi Ed,
Try looking here, lots of info on dependant drop downs. http://www.contextures.com/xlDataVal02.html HTH Regards, Howard "Ed" wrote in message ... Hi, I've got a problem which is a little difficult to explain so bear with me! Firstly I'd like do have two drop down boxes which flow through each other. So Box One has 1,2 and 3 as options, for example. If Box One selects "1", Box Two would offer 1,2,3. If Box One selects "2", Box Two would offer 4,5,6 etc. Based on the final outcome in Box Two I'd like the cells to the right of Box Two to show specific information. Is this possible? I'm effectively trying to put in a scroll option for a number of Rows where only the Row currently selected can be seen, to tidy it up a bit. If anyone has any ideas on this it would be greatly appreciated. This is my first time on here and there is a wealth of info and it's a great source of learning! Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Drop Downs Or Combo Boxes to Look up and display Info | Excel Discussion (Misc queries) | |||
Combo Boxes | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
combo boxes | Excel Worksheet Functions |