View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KD[_5_] KD[_5_] is offline
external usenet poster
 
Posts: 17
Default 3+ Dynamic Dependent dropdowns?

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