Populate ComboBox Based on Selection in Another ComboBox using Excel VBA

This video demonstrates how to populate a ComboBox based on a selection made in another ComboBox using Excel VBA. Excel VBA code is configured so that a ComboBox selection dynamically sets the rowsource of a second ComboBox.

[@crazyfellowindian]

Thank you Todd, I was searching for this code for a long time.

[@DrGrande]

You're welcome!

[@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.

[@Alex-od7nl]

wow, you also do vba tutorials? Nice!

[@ransaput5900]

I haven't seen the code for the textbox when you click the combobox2. Please, let it include also for the reference. thank you so much.

[@debasishdash6277]

hey nice video. have doubt can't we add data directly from combobox instead of bringing it to textbox.

[@Sebbiecool18]

Thankyou for your video!! Super helpful! However when i try combobox1.RowSource = "Disorder", i keep running into "runtime error 380, Could not set the RowSource property. Invalid property value." Any idea why and how do i over come this error?

[@stuartanderson3713]

Hey, great video. Just what i needed. It worked! :)

[@DrGrande]

Thank you!