Dear all,
I've created a userform with a lisbox in which appears all the Spanish districts. Once a district is choosen , I would like to generate a second Listbox to display all the cities of the choosen district with a command button.
Userform with the listboxes shows off in the worksheet "Inicio" once clicked on "Espaņa".
Data used for ListBox1 relies in the worksheet "Destinations".
Column "B" holds the names of all districts for ListBox1.
Column "C" holds the names of all cities for ListBox1.
Column "C" holds the city names of district 1, Column "C" holds the city names of district 2, Column "D" holds the city names of district 3, and so on....
My problem is I can`t figure out how to define the variable in order to generate a second userform with a Listbox2 linked to the first one. Until now, I only could insert the two Listboxes in the same userform.
Anyone an idea how to write this VBA Code?
Please find attached the XLSM document
Thanks a lot in advance.
Figolu
Bookmarks