Dynamic ComboBox (Drop down) menu in a VBA UserForm

Hi all,

I need help with creating dynamic ComboBox menu in a VBA UserForm.

In the sheet "Pickup list" I have list of regions in the world. Also, for each of the regions I have list of the countries in it.

When in the "Start" sheet I click the green "Start" button, a UserForm will popup with 2 ComboBox.
The list in the first ComboBox (Region) is coming from the "Region" list in the "Pickup list" sheet (this are cells A2:A12).
The list in the second ComboBox (Country) should be depended of the value which is chosen in the "RegionComboBox.
E.g. If I choose for region "Baltics", in the Country field, the ComboBox should show me only the countries in this region. If I choose another region, the Combo box to show me only the countries from that region.

Thank you in advance for your help.

Igor

Dynamic VBA drop down list.xlsb

Try this one.

Hi Bakerman2,

Thanks for the fast reply. Is it possible to have the dynamic ComboBox without grouping the data columns together? In the file with which I need to work, the region list in column V, while the country list are in the columns X:BB.
Thank you in advance.
Igor

Check revised file.

PS Have put value in W1 of Pickup list for CurrentRegion to work.

Hi Bakerman2,

That works perfectly.
Thanks a lot!!!

Igor

You're welcome and thanks for the rep