Combo Box Linking
 

Hi Everyone

On a userform I have 2 drop down combo boxes

CBox1: has 4 names of cities - London - Manchester - Birmingham - Edinburgh

Cbox2: has 4 names of Excel Sheets with the same names as above

The problem I have is that on selecting CBox1 - London and CBox2 - London -
it populates ListBox1 with all the correct details of the London Sheet.
However if I select Manchester in both ComBoxes it still populates the
ListBox1 with the London Sheet Details and not the Manchester Details that
are required. Is it possible to have the listBox1 select the correct Details
Sheet when selecting different cities.

Any help much appreciated

Cheers

Mully