Create Dependent Combo Boxes on a Userform - Excel VBA

[@essamelrifai4551]

Thanks a lot

[@Computergaga]

You're welcome.

[@jeni448]

Thank you it works!

[@Computergaga]

Great! You're welcome.

[@yael9614]

Thank you!!!

[@Computergaga]

You're welcome!

[@LordBransty]

I'm losing count of how many times you keep coming to my rescue. Thank you so much for this!

[@Computergaga]

You are so welcome!

[@suhailabahrom.4560]

If the list of item of second combobox is not in the excel what is the correct way to write the command in vba to list the item

[@ronaldodoetargbeh5158]

Thanks for this tutorial; nice. However, how can you reference this code to a sheet if you have multiple sheets (e.g. sheet1, sheet2. sheet3, etc.)? Thanks for your help.

[@stevennye5075]

Excellent!

[@Computergaga]

Thank you, Steven.

[@MohAboAbdo]

Thank you so mutch.

[@Computergaga]

My pleasure.

[@markanthonydizon50]

what if I want to pull out data from different sheet?

[@Computergaga]

The City lists are set up as range names, so they will pull from another sheet.

[@wazy1852]

How can I do this but inside the Excel sheet using the Combobox tool, not using the userform? thanks

[@sircorn4248]

Thank you, that was an eye opener for me.

[@Computergaga]

Fantastic! Great to hear.

[@chocasaclang]

Thanks for the video, just wanted to ask if there's a way to reset combobox 2 when combobox 1 is changed again? Here's the scenario im getting: i choose country germany the first time then i see the cities, but if i go back and change the country, it keeps the german cities on the city dropbox unless i close the userform and start over.

[@legros94]

Merci pour le tuto

[@Computergaga]

You're welcome Hiro.

[@ismailismaili0071]

Awesome thanks sir

[@Computergaga]

You're welcome Ismail.

[@SaniaGestion82]

That's wath I'm looking for to finalize my formular Thanks a lot Dear

[@Computergaga]

You're welcome. Thank you.

[@litmol]

Thanks for the code and the detailed explanations - it’s highly useful. I tried taking your code one step further and failed. I would like to use three ComboBox in the following manner: the third ComboBox should present values (Names) based on user’s selection in the first two ComboBox (Company and Division). Could you kindly advise how to amend your code to make it work with three ComboBox? Thank you in advance.

[@Computergaga]

Thanks Tal, you could set up named ranges for each company and division combination. Then maybe instead of Select Case, is an If cboCompany.value = ?? And cboDivision.Value = ?? then approach. Using the row source as in the video.

[@litmol]

Thnaks for the tip. I'll give it a try

[@litmol]

I tried and it works! Thanks again for the useful advice

[@hamassa55]

Tal Shani Can you share the final code with three combobox

[@litmol]

@@hamassa55Sure. I don't have the code on this computer, so I'll post it tomorrow. It's basically very simple - combine the content to the first two comboboxes to one string and then use an If statement to populated the third combobox based on the value of the string. If that wasn't clear, please wait till tomorrow morning.

[@AdilsonVCasula]

That was so simple. Great done

[@Computergaga]

Thank you Adilson.

[@sachinbajaj5137]

This is super helpful ! This is what i was looking for ! Thanks a Ton !

[@Computergaga]

You're very welcome. Thank you.

[@maherzeetawi508]

I tried it was perfect.. But after trying that with button several times then closed file reopened the file it was not working even made new file & followed the same steps but unfortunately not working... Hopefully can get help... Thank you

[@vigneshwarank529]

Awesome content thanks for sharing

[@Computergaga]

You're welcome, thank you Vigneshwaran.

[@jochenp.6137]

Love it, thank you!

[@Computergaga]

You're very welcome Jochen.

[@nextstep2239]

I'm getting compile Error

[@StephenE-mx5fe]

Just what I needed thank you!

[@Computergaga]

No problem Stephen.

[@cire411]

How are you sourcing the country CBO?

[@Computergaga]

The countries are sourced from A2:A8

[@hamassa55]

I followed all the instruction and its not showing data in the drop box when I try to run it

[@dannywoods5216]

Mine is not working either. Try this one: kzbin.info/www/bejne/j3qopZKJa5p6qLc

[@VijayKumar-zd7ou]

Sir, can we do this only combo box without user form

[@Computergaga]

Yes this could be done of a worksheet too.

[@VijayKumar-zd7ou]

@@Computergaga please send me sample excel on my mail id please help me

[@VijayKumar-zd7ou]

I can't do this apply on ActiveX Control combo box on sheets

[@nextstep2239]

Error invalid qualifier

[@stevenojeda6513]

How would you do this if there is three combo boxes instead of two? The code is magnificent but I can't see how to apply it to 3. I have five combo boxes that are dependent but hopefully if you show me how to do three I can build the rest.

[@MyMomSayNoDota]

i dunno why, but i hate to set data without table and use SELECT in the vba code.

[@gun707]

nice approach, however, try using 1 line code without the need of typing all names again: private sub cbocountry_change() cbocity.value = "" 'clears the combobox first when country is changed cbocity.rowsource = cbocountry.value 'replaces manual name entry end sub

[@disposable_hero1725]

Auckland, New Zealand, Represent!! LOL

[@tomo.pomo1]

👍👍👍👍

[@petrusedwardjr.2598]

Why would you start off the video not showing how u got the two combo boxes in Visual Basic. When u press Visual Basic two combo boxes don’t magically appear

[@Computergaga]

Sorry about that but I cannot start all videos from the beginning. I would need some prepared data before I show the formulas, chart or in this case dependent combo boxes.

[@kimikimkimkimkimkim8125]

How to do this on Access?

[@Computergaga]

Sorry I do not work with Access anymore. I'm sure the process would be similar with VBA.

[@dhirendrakumar1656]

How did you do that. It is not working on my userform of Excel vba. Will you please help me? Give me your email ID.

[@VijayKumar-zd7ou]

Sir please provide me ur email id I send to u sample file what I want

[@Computergaga]

Sorry Vijay I can't help you with this at the moment. Combo Boxes added to a sheet have a name. You should be able to reference this like in the video.