Fully Dynamic List in ComboBox Excel VBA || Dependant ComboBox VBA || ComboBox in userform

This tutorial help you the to clear the idea about ComboBox.
It is fully dynamic ComboBox and also dependant Combobox.
If you have mixed of data on your worksheet and you want to separate it as you like. Then It is perfect for ComboBox in excel vba.
for practice file click below
drive.google.c...

[@trader128tan8]

Hi Sir, thank you for the code. I just realized if there are similar sales person for both Manager 1 and Manager 2, these sales person will not appear in combo box 2 if Manager 2 is selected in combo box 2. e.g. If "Mr. J Roy" is also under Manager 2, when Manager 2 is selected in combo box 1, "Mr. J Roy" will not appear in combo box 2. Is it possible to modify the code to make this possible? Desperately need help on this and I could not find any solutions online.

[@WillOkazaki]

Sir, how do I start my board from B3 so that the comboboxes can work? help please...

[@dayanandvishwakarma6389]

Sir, if same name for for manager 1 & manager 2 then what will change in code

[@sekousane8051]

Hi Thanks for this...
It's work done...
But this time I wanna know if the 3rd part to display result is a listbox And not a combobox like this video what we go n'a do ???
Please ANSWER !!!!
Thanks you again !!!

[@rksocial9354]

Thank you Sir, using this method I have created a file with 5 category of ComboBox but I have ons doubt on how to speedup run time in Macro in userform? Please assist

[@kamranmammadov9546]

Thanks for the information. Can you help to pass the data in the listbox to the table? Thanks in advance

[@amirrsssss]

This one helps me a lot! Thanks bro

[@TheNewLifeTech]

thanks for this video, Can we make more then three dependent combobox?

[@Nsutradhar]

Yes, you can

[@hardik_parmar_2301]

Please Share More Than 3 Dependent Combobox Example.
[e-mail]

[@todorpetkov1217]

Hello Mr. Nsutradhar, trying to follow you and complete this program alone, I mentioned a problem when info in the area is not sorted (Columns A, B, C - not sorted) in this situation function:
Application.WorksheetFunction.CountIf(sh.Range("B4", "B" & i), sh.Cells(i, 2)) = 1
doped earliest. Do not go to the bottom of column B and with that ComboBox2 not add all items I have it.
So, what is wrong?

[@maharajatradingcompany8729]

bro you need to use countifs function and mention both the columns together in one formula, then it will work

[@kaitlync2024]

I noticed the same issue as the previous comment. Can you please help?

[@shatrughan08]

sir ji mere combobox three mai kuch show nahi ho raha hai apke dwra batai puri coding ki hai phir bhi plz help

[@dayanandvishwakarma6389]

if manager 1 and manager 2 has same name employ then how this work

[@NAJIB4U]

Thank you so much, realy its a very helpfull tuto ;)

[@Toto-pw4tw]

Thank you so much! This is a very helpful video!

[@eleonoraa.c.1706]

Thx a lot. Your method is the best.

[@yuslanld7956]

Best. Thanks so so much

[@Nsutradhar]

Thanks

[@kuppandampalayamsociety5863]

Thank you so much bro

[@kirandey26]

Great Sir, thanks for this video

[@vo_chong_aphu]

Thanks for this video!

[@rodrigopresencebagarolo2892]

Nice video, thanks!

[@Lone.wolf004]

Thank you sir :)

[@amdadulbd3983]

thanks

[@tareqrahman2702]

Many Many thank, i am just looking for this formula.

[@Nsutradhar]

thanks

[@TheNewLifeTech]

Very useful

[@chiragkothari2306]

Sheet1 a to c value combobox1 to 3.and Sheet1 d value textbox1 show
Please send to code

[@chiragkothari2306]

Please share your WhatsApp number

[@Nsutradhar]

[e-mail]

[@chiragkothari2306]

8460193000

[@Nsutradhar]

Sir please send your queries at [e-mail]
I will definitely reply. I checked my email regularly.
I will solve your problem and send you necessary code. No need to share whatsapp number.
And also if you face any problem with any application which you are going to create. You can share with me.

[@dayanandvishwakarma6389]

Sir, help

[@Nsutradhar]

Contact me at [e-mail]
With full description

[@dayanandvishwakarma6389]

Sir, we have already send