VBA: Multilevel dependent drop-down in User Form

[@miguelberganza6193]

You just singlehandedly saved my job, thanks man!

[@PKAnExcelExpert]

Great to hear!

[@SurajRajSomarajan]

GREAT VIDEO TOOK 3HRS BUT ALL I WANTED IS CREATED GREAT I FIND THIS VIDEO THANKS MAN

[@PKAnExcelExpert]

Thanks for your appreciation. Request you to please share this with your friends.

[@icydragon542]

Thank you sooo much. I've been trying to find this for the past 2 hours. You are amazing. I appreciate you so much! Gave it a thumbs up + Subbed.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pxgvsvs]

Very helpful really save me lot hour of complicated coding that i was going to do.

[@PKAnExcelExpert]

Glad it helped!

[@michaelsmits8677]

It might sound overwelming in the video but if you download the excel file and study it in at you own pace it makes, like most things in VBA, perfectly sense. It's pure logic and nothing else than spep by step thinking. It helps me if I difine speaking to myself what steps would be necessary to archive a certain goal. VBA and scripting generaly do the same. So don't gwt intimidated but just take a good look at the sheet. Thanks for explaining it to me.

[@PKAnExcelExpert]

Most welcome

[@hafizhzhafran6358]

Thank you sir, very simple explanation and powerful!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@MM-oe2eo]

Thank you, easy illustrations. Simple to follow.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shashankshastry8416]

Amazing the code is perfect for my need. Thank you very much.

[@michaelbedano3265]

Nice tutorial. Thanks for the video. Do you have a tutorial regarding on searchable dropdown list in a userform combobox?

[@wapwap6189]

Very informative video Looks so good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wapwap6189]

@@PKAnExcelExpert i have vba question can you solve that

[@pratapgc]

Very informative video. Thank you!

[@PKAnExcelExpert]

Glad you enjoyed it!

[@rajikumar5171]

Really great thank you so much 😊 awesome keep it up

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hoangtung8080]

Great, Thank you very much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheNewLifeTech]

This is very useful for me, this source pattern not user friendly, and can we change the source pattern

[@alirezamogharabi8733]

So helpful, Thanks

[@PKAnExcelExpert]

Most welcome

[@DilipTiwariVlogs]

Awesome Bro!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@GL-gj8ds]

very good video ! Thanks a lot ! :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@BB-os8ix]

Nice 👍 are giving online training’s?

[@BalanRaluca]

very useful solution! can we use same code but use only excel cells without VBA User form?

[@PKAnExcelExpert]

Yes, we can, please watch the below video: kzbin.infoU8TVB_KbgWY

[@subhamthakur3334]

Sir please make video on web scrapping through VBA

[@PKAnExcelExpert]

Sure Subham I will make such video very soon

[@subhamthakur3334]

PK: An Excel Expert sir can I got your email id I have some queries

[@ghanshyamsingh6411]

Nice tutorial

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AshishKumar-uk9gi]

Superb, I like it.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@akshayhandoo]

That was a nice video, sir. Will the same be possible without using VBA and just the dropdown selection from a table of data, no Combo-box required. Would be really helpful if you can prepare a video of it.

[@SyedMuzammilMahasanShahi]

Thank you for sharing this video

[@PKAnExcelExpert]

Thanks for watching

[@kalcerro1]

Great video, and great information. How can I manage the information to appear when I have numbers only in category and subcategory?

[@himadrichakraborty7509]

it is very informative video, thanks for your effort and clarity given. But I have a full set of master data of item chronology and according to that I need to create 5 dependent combobox. Can you please help.

[@PKAnExcelExpert]

Thanks for your valuable feedback. You can use the same method. For more details please download this excel file from the link given vedio's description box.

[@BJtalkchannel]

I Like the video BK. help me lean a lot on VBA. Can you show how to do a combo box depending on other values on excel and do not show duplication value in combo box and I do not want to hard code category, sub category and etc. basically, column A, contain Computer, B -Column, Model # and C -column value. a computer has many model # and Serial number for me. If i choose computer, it will give me list of model# . Thanks

[@manohauptmann1038]

Hi!! Thank you for this great tutorial. Could you please give me the code for the use of four Listboxes instead of the comboboxes. This would be realy wonderfulThank you for your support!!!! Bye

[@bykursadtufan]

Thank you so much :)

[@brockdavis30]

This an excellent tutorial. I'm having an issue with my data which is a mixture of text and numbers (NA, 13, 14, 15, etc.). My first drop-down box works perfectly but the second drop-down only displays the NA value and the third drop-down box is empty. Do you have any thoughts on what my issue could be?

[@brockdavis30]

Never mind. I figured it out.

[@Neurobot]

Perfect! Thank you so much!!

[@PKAnExcelExpert]

Glad it helped!

[@MohAboAbdo]

Thank You So Mutch

[@PKAnExcelExpert]

Thanks for watching

[@SunilKumar-uv6zu]

hi.. can you throw your skills on india map.. like we select any state from dropdown and it gets highlight that particular state region on india map..

[@PKAnExcelExpert]

Hi sunil, I will definitely try to make such video very soon

[@ninety9million928]

How do you clear the fields using a clear or reset button?

[@quincyirang2543]

Tq Mr PK . I need your help on how to make parenthing for my case. If I can send you the excel document, it would help

[@quincyirang2543]

The case is 1. Candidate A,B,C will contest in DUN name ACEH under Parliament MARANG 2. Candidate D,E,F will contest in DUN name MELONG under Parliament KURAU 3. Candidate G,H,I will contest in DUN name KELOTEH under Parliament MARANG 4. Subdivison DUN ACEH is KEMANG, RANJUR, RAMIS, BORONG 5. Under Subdivision KEMANG is, MALI,KERTEH,BANGKU,KERUSI 6. Under Subdivision RANJUR is, TUTUP,AIR,TISU,LIMBING 7. Under Subdivision RAMIS is, BIRU,PUTIH,COKO,KERI 8. Under Subdivision BORONG is, KULIT,KAIN,KIKIR,SLIMUT 9. Subdivison DUN MELONG is JAMAR, KATIL, BUNGKUS,TIANG 10. Under Subdivision JAMAR is, KENAL,TAKBAI,KERJA,KERTAS 11. Under Subdivision KATIL is, KAKI,TANGAN,KAIN,PLASTEM 12. Under Subdivision BUNGKUS is, NASI,IKAN,KICAP,SAMBAL 13. Under Subdivision TIANG is, KAYU,MERANTI,MARMAR,CENGAL 14. Subdivison DUN KELOTEH is MACEH, POK, PAKDAN,KECEK 15. Under Subdivision MACEH is, TOKSEH,MAEL,KENTANG,REPAK 16. Under Subdivision POK is, KELIK,KETAL,LONSO,LONEK 17. Under Subdivision PAKDAN is, PEKAN,PAHANG,MEDANG,SERIK 18. Under Subdivision KECEK is, KELATEH,RETREKE,RALAT,KUNJIT I hope the case not hard for you tq.. Please send to my email [e-mail]

[@medkari]

Thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@121PCOTRAINING]

Hi questions answers how can prepare in drop down box

[@gerardvaneggermond9967]

Hello, maybe you can help me, I would like to find a user form with a dropdouwn list, the first list (for example worksheet "S1" to "S3"), the second a list of names, then I want to look up data in an existing worksheet underneath each other, if there were empty cells in that worksheet that should not be displayed. There are max. 20 names. can you help me to make something like that?

[@haris88reddy]

Sir, can u help in writing vba for transferring data from Excel to another Excel using Combobox text, from date and to data.

[@rez2109]

Hi Mr PK, I have tried your tutorial but the code seems to work for only 1 questions only. Actually I am having several questions that need to use multi level drop-down list. The rest of the questions the drop-down list does not appear. Please help or how can I can share my excel for your review? Thank you. Your follower from Malaysia

[@gerardvaneggermond9967]

Hello, maybe you can help me, I want to create a user form with a drop down list, but I want to search in three different worksheets, they are all the same, how can I do that?

[@VijayKumar-zd7ou]

Sir this condition working without user form on combo box ?

[@prosantodas9280]

Nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@waseemali433]

I want to take class from you... I will pay you whatever you want, in fact my full salary also😪🙏🙏🙏

[@PKAnExcelExpert]

Thanks Waseem. I don't provide any kind of paid classed or paid services.

[@waseemali433]

@@PKAnExcelExpert but how will i learn

[@amarsehgal1745]

Hi Sir, Its was a nice video. Can u help me I have to make form for a school to retrieve details with admission number.

[@prosantodas9280]

I need to category, subcategory, item details report and according to date, like 1-30 or 7 - 15 and as usual, plz upload the tutorial, tnx

[@sandeepkesavan4067]

how to do the same if contents are in different sheets

[@iggyboyTV]

Sir can you help me to resolve my problem on my project

[@sumank2190]

How can I Get Submit command button coding....????

[@kalpeshkc]

I need this code for visual studio form

[@rkexcel2686]

sir userform me close option hide karana he kese hoga please tell me

[@djkatz7821]

If the previous combo box is a number then the next combo box is blank

[@mrtechguru341]

Sir this video was not on this topic which I asked you

[@poptanivinod]

sir PK i need to contact you and learn a lot in excel how i contact you

[@BkPtYn]

How to replace "Me" I can use it in my work 😂

[@salauddin2322]

you are good but this will no help to data base.

[@manohauptmann1038]

sorry... i discovered my mistake in coding... ;-)

[@pankajtiwari2706]

Sir Hindi Me vedio bnao

[@ghanshyamsingh6411]

Ho

[@crisrule9502]

confusing use simple data

[@mrtechguru341]

Plz bro reply me

[@PKAnExcelExpert]

I have sent you email yesterday. Please check it

[@rjc971]

What a trash website, cant even locate where to download the file. Seems like a great place to download some virus.