VB.NET will not solve that problem, it is a logic issue which would remain
in VB.NET, so you have to work out a way of constructing the data so that
you can access. I agree my technique gets very messy after 3 combos, so
maybe the best way is just to list all the addresses and dynamically extract
the relevant data.

So you would

Build a unique list of continents and load into Combo 1.
On selection from combo 1, build a unique list of all countries in that
continent, and load combo 2
etc.
etc.

Not very difficult, even without VB.NET.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KD" wrote in message
oups.com...
Does any one know a more efficient routine?

http://www.xldynamic.com/source/xld.Dropdowns.html is pretty easy to
get bogged down in.

Say it's Continent=Country=State=City=Street=number


I think I am getting to the point where I need VB.NET or C#. Have any
of you made the transition with the intention of improving your
spreadsheet applications? I am in Energy Risk Management and we deploy
Excel models all the time, but Excel can be squirrely when your talking
about 6 cascading comboboxes on a userform. It's also not very secure.

I know it's two threads. I am most interested in the first question.
On the second I am fatalistic (I have to learn it, so who cares if
learning C# hurts.) Food for thought.

Thanks and Cheers,

James