Returning arrays from arrays....

[Magsy]

Hi,

I´m using drop down menus for users to make certain selections. The first dropdown list refers to column A in the array, the second to B and so on. What I want to do is to dynamically update the "downstream" dropdown lists as the user updates their selections.

For example. If column A is Continents, B is Countries and C is cities. If the user selects "Europe", the second dropdownlist should discard all countries outside of Europe and only display the countries in Europe.

The reason I want to do this is that there are thousands of cities column C (some of which everyone knows what country they´re in, some not so obvious) and it´s important that the user doesn´t get huge drop down lists all the times.

The final step will be to return a reference code for each city.

I´ve been banging my head against the wall with this problem for the past week and just realised the method I have been using won´t work. Due to the people that will be using the program, it has to be written in excel.

Any help is much appreciated.

Thanks
Magsy

[sweep]

Hi,

I think you'll find what you're looking for here

http://www.contextures.com/xldataval02.html

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html, almost exactly your example.