ComboBox dependable for another ComboBox in Userform

[Hany ali]

hello my Masters
i want to help you to get data and List for ComboBox 2 ,when i choose any Country from ComboBox1
ComboBox1 ALL Country
ComboBox 2 all cites for country list shown in ComboBox1
thanks alot

 

[AlanSidman]

https://contexturesblog.com/archives/2013/03/07/excel-userform-with-dependent-combo-boxes/

 

[Hany ali]

thank you
I looked at this topic before, but I did not benefit from it. I have more data than the uploaded file, so this example does not work for me

 

[Belleke]

See example.
I made tables of your cities lists, if you add new cities in the future the lists in combobox 2 are updated automatically.

 

[Hany ali]

thanks alot ...This is exactly required
but we haven't any way to answer without Name Manager ,becaouse my main file Contains more than 100 countries, this Way will be very stressful
if you can possibe to be by this way ,which i make it in file by Drop DownList ,but i want as i sent before in Userform .This is because I couldn't apply the same idea in the Userform
as you see i used this formula to make List for Cities whwn i choose any country in Data Validation

=OFFSET(INDEX(Sheet2!$M$3:$Y$30,,MATCH($D$9,Sheet2!$M$2:$Y$2,0)),,,COUNTA(INDEX(Sheet2!$M$3:$Y$30,,MATCH($D$9,Sheet2!$M$2:$Y$2,0)),1))

 

[Belleke]

Yes,this is possible
Example for Egypt

ComboBox2.RowSource = Range("M3:M" & Cells(Rows.Count, "M").End(xlUp).Row).Address

 

[Hany ali]

of course it's Better thank you ....
I apologize for you, I have tired you so much
God bless you

 

[Belleke]

Glad to help.