Several dynamic listboxes

[Sql7user]

Hi,

In Excel I want to put 2 or more listbox/combox that are dynamic and linked. Depending of the choice I make in the first i get choices in listbox 2 etc. For example, I choose countries in listbox 1, get the cities in number 2 and in number 3 I get the streets.

I have no idea how to make this so plz explain in detail.
Thanks in advance!

/Sql7user

 

[GlennUK]

Have a look at this thread ...

thread68-374286

many solutions in here ( including one by me ).

Cheers, Glenn.

 

[Sql7user]

Thanks Gleen!!!

There were many nice solutions for me to solve my problem.

Cheers, Sql7user

 

[MeGustaXL]

Also have a peek at this site:

http://www.erlandsendata.no/english/downloads/userforms.php

The "UserForm2" download file Synchlist.xls does the job, but it does use VBA, and the macros are in Norwegian!

Cheers, Chris