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.
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
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.
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?
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.
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.
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?
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
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?
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
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 quincy_ms79@yahoo.com
You just singlehandedly saved my job, thanks man!
Great to hear!
Very helpful really save me lot hour of complicated coding that i was going to do.
Glad it helped!
Thank you sir, very simple explanation and powerful!
Thanks for your valuable feedback🙏
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.
Thanks for your valuable feedback
Thank you, easy illustrations. Simple to follow.
Thanks for your valuable feedback
GREAT VIDEO TOOK 3HRS BUT ALL I WANTED IS CREATED GREAT I FIND THIS VIDEO THANKS MAN
Thanks for your appreciation. Request you to please share this with your friends.
Amazing the code is perfect for my need. Thank you very much.
Very informative video
Looks so good
Thanks for your valuable feedback
@@PKAnExcelExpert i have vba question can you solve that
Very informative video. Thank you!
Glad you enjoyed it!
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.
Most welcome
Nice tutorial. Thanks for the video. Do you have a tutorial regarding on searchable dropdown list in a userform combobox?
Great, Thank you very much
Thanks for your valuable feedback
Really great thank you so much 😊 awesome keep it up
Thanks for your valuable feedback
very good video ! Thanks a lot ! :)
Thanks for your valuable feedback
So helpful, Thanks
Most welcome
Awesome Bro!
Thanks for your valuable feedback
Perfect! Thank you so much!!
Glad it helped!
Thank you for sharing this video
Thanks for watching
This is very useful for me, this source pattern not user friendly, and can we change the source pattern
Superb, I like it.
Thanks for your valuable feedback
Nice tutorial
Thanks for your valuable feedback
Nice 👍 are giving online training’s?
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
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.
Thank you so much :)
Great video, and great information. How can I manage the information to appear when I have numbers only in category and subcategory?
very useful solution! can we use same code but use only excel cells without VBA User form?
Yes, we can, please watch the below video:
ruclips.net/user/shortsU8TVB_KbgWY
Thank You So Mutch
Thanks for watching
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..
Hi sunil,
I will definitely try to make such video very soon
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?
How do you clear the fields using a clear or reset
button?
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.
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.
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?
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
Hi questions answers how can prepare in drop down box
Sir, can u help in writing vba for transferring data from Excel to another Excel using Combobox text, from date and to data.
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?
Never mind. I figured it out.
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
Sir this condition working without user form on combo box ?
Thank you so much
Thanks for your valuable feedback
Sir please make video on web scrapping through VBA
Sure Subham I will make such video very soon
PK: An Excel Expert sir can I got your email id I have some queries
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
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
quincy_ms79@yahoo.com
how to do the same if contents are in different sheets
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.
Nice
Thanks for your valuable feedback
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
Sir can you help me to resolve my problem on my project
How can I Get Submit command button coding....????
I need this code for visual studio form
If the previous combo box is a number then the next combo box is blank
sir userform me close option hide karana he kese hoga please tell me
sir PK i need to contact you and learn a lot in excel how i contact you
I want to take class from you... I will pay you whatever you want, in fact my full salary also😪🙏🙏🙏
Thanks Waseem. I don't provide any kind of paid classed or paid services.
@@PKAnExcelExpert but how will i learn
Sir this video was not on this topic which I asked you
Hi
you are good but this will no help to data base.
How to replace "Me" I can use it in my work 😂
confusing use simple data
Ho
sorry... i discovered my mistake in coding... ;-)
Plz bro reply me
I have sent you email yesterday. Please check it
Sir Hindi Me vedio bnao
What a trash website, cant even locate where to download the file. Seems like a great place to download some virus.