Sub-menus principle with combo/drop boxes?

dan2 · Mar 31st, 2002, 06:09 AM

Is it possible for combo/drop boxes with in a sheet to go into a sub-combo/drop box in the same way a menu does.
i.e.
combo/drop box list of countries
select England
Sub-combo/drop box appears with cities in.

I would love to find out if this is possible and if it is how to do it?

Many thanks in advance for your knowledge

)

Dan

Ian Mac · Mar 31st, 2002, 06:31 AM

Yes, it is entirely possible.

pivot table would be one way, I don't use them very much so I can't offer much advice.

I do however have an alternative solution using a lot of INDIRECT() functions, I have an example workbook I created for someone else a while a go, I'll send it to you if your interested?

Cosmos75 · Apr 1st, 2002, 04:25 PM

If you go to OzGrid.com and checkout the examples/downloads, there is one called ChangingCombos2.zip that is what you are looking for.

Here's the direct link to the file:

http://ozgrid.com/download/ChangingCombo2.zip

Mar 31st, 2002, 06:31 AM	#2
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Yes, it is entirely possible. pivot table would be one way, I don't use them very much so I can't offer much advice. I do however have an alternative solution using a lot of INDIRECT() functions, I have an example workbook I created for someone else a while a go, I'll send it to you if your interested? __________________ "Have a good time......all the time" Ian Mac

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 31st, 2002, 06:09 AM	#1
dan2 Board Regular Join Date: Mar 2002 Posts: 60	Is it possible for combo/drop boxes with in a sheet to go into a sub-combo/drop box in the same way a menu does. i.e. combo/drop box list of countries select England Sub-combo/drop box appears with cities in. I would love to find out if this is possible and if it is how to do it? Many thanks in advance for your knowledge ) Dan

Apr 1st, 2002, 04:25 PM	#3
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	If you go to OzGrid.com and checkout the examples/downloads, there is one called ChangingCombos2.zip that is what you are looking for. Here's the direct link to the file: http://ozgrid.com/download/ChangingCombo2.zip