using two comboxes... to populate a third

Hi Guys,

If you look at the attached file, you will see that I am using one combobox to populate the second.

as follows:

Private Sub ComboBox_Region_Change()

Select Case Me.ComboBox_Region.Value
Case "NORTH AMERICA"
    Me.ComboBox_Country.RowSource = "NORTHAMERICA"
Case "NORTH AMERICA"
    Me.ComboBox_Country.RowSource = "SOUTHAMERICA"
Case "EUROPE"
    Me.ComboBox_Country.RowSource = "EUROPE"
Case "ASIA"
    Me.ComboBox_Country.RowSource = "ASIA"

End Select
ComboBox_Country.SetFocus

End Sub


Private Sub UserForm_Initialize()
Worksheets("Lists").Range("NORTHAMERICA").Name = "NORTHAMERICA"
Worksheets("Lists").Range("SOUTHAMERICA").Name = "SOUTHAMERICA"
Worksheets("Lists").Range("EUROPE").Name = "EUROPE"
Worksheets("Lists").Range("ASIA").Name = "ASIA"

Worksheets("Lists").Range("REGIONS").Name = "REGIONS"
Me.ComboBox_Region.RowSource = "REGIONS"

End Sub

This works great - only i want to be able to have a third combobox look at the result of combobox_County and populate combobox_location (the 3rd combobox)

Any ideas?

Thanks a million