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