Populate ComboBox Based on Selection in Another ComboBox using Excel VBA

preview_player
Показать описание
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.
Рекомендации по теме
Комментарии
Автор

wow, you also do vba tutorials? Nice!

Alex-odnl
Автор

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.

ransaput
Автор

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.

litmol
Автор

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

crazyfellowindian
Автор

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

stuartanderson
Автор

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

debasishdash
Автор

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?

Sebbiecool