Fully Dynamic List in Combobox of VBA

[@hansasare4078]

Awesome videos...Your VBA tutorial videos is one of the best I have seen so far...well done and God bless you Sir

[@PKAnExcelExpert]

Thank you very much!

[@arkd3um1988]

much respect for your effort to explain this example. Thank you. It is exaclty what i needed. Regards from Romania

[@PKAnExcelExpert]

So nice of you

[@M4rt1nX]

Finally I found a video with instructions that really works.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alikilali2249]

Me to 1 month to find it thank you man

[@BINAYKUMAR-kn2ye]

Dear Sir, First I thankful to you for send Inventory Managment for practice , in that practice I serch verious Utube channel for serching dependent combobox but I spent 5 hours but not good for me then in meanwhile I look Fully Dynamic List in Combobox of VBA that I am surprise in few code I have done my problem with many facilities, for this I am highly oblize . thanks again.

[@معلمسالم-ك2ج]

I am an Arab and this video helped me a lot .. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@choudhary8150]

Thanks . This is the video what I exactly want.... really it's very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anmarhakami]

You are good 👍🏻 thanks 🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@tariqul199]

Sir, really you are great!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ardeshiraqayi9976]

Sooooooo useful... Tanks a lot brother ...

[@paulocezardesouza50]

Another excellent class. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@marcioaffonso0]

Thank you, Very informative

[@PKAnExcelExpert]

Most welcome

[@mathsever34]

Perfect! Is it possible to have a combobox as category 1, category 2, category 3?

[@jintamolp.y.2230]

Whether we can do it if multiple sheets are present

[@Kutesac]

Great instructions...very understandable.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@slimaneboudour8240]

Thank you for this video.

[@PKAnExcelExpert]

My pleasure!

[@a.b.c.0.2]

Thanks for good video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RaviMishra-hh8dx]

Thank you very much sir for this relevant video to my work can you plz teach us how to view data from excel sheet according to 3 or 4 combobox filter.

[@chesterjackson4690]

Great lesson. However, I continue to have a runtime error '1004'. The overall function works properly until I added in the code for clearing the fields. When I remove the code starting at 7:41 everything works great. I guess I will need to remove that existing combo box and add in a new one and resubmit the code. Overall....very helpful

[@JGuitarJ24]

Hi Chester, How did you fix this problem? I am facing this issue right now with the clear button and I do not know what to do. Thanks

[@keyingong6728]

Hi Chester, is the issue resolved? Do you mind to share the solution?

[@LearningWhileHavingFun]

Hi An Excel Expert, i learned a lot and i am following your tutorials, just curious whats the formula because at 9:50 the video got blurry hope you can help me or any one can help me with this. ty

[@alikilali2249]

Thank you man for this video

[@PKAnExcelExpert]

Welcome

[@TimHulse]

Nice work!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@muhammadakif5951]

Sir if I write the first letter of any month or year will the drop-down list show only those items that start with the letter I have entered?

[@abdallahbelcaid3002]

Please answer me I got an error 1004 c=application.worksheetfunction,match(me.combobx1.value,sh.range("1:1"),0) geta an error saying that "unable to get the match property of the worksheet function class"

[@tmatthew5373]

take out the ".worksheetfunction."; just using "application.Match". This changes the error type from 1004 to 13. Error 13 is a type mismatch. This happens because you declared variables as integers, but when the values are assigned/used, they may be Text. (Dim i As Integer. This later can change to a text in 'Me.ComboBox2.AddItem') As a work-around, add a 'On Error Resume Next' in the second part of the code Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Setup Table") Dim i As Integer Dim n As Integer On Error Resume Next n = Application.Match(Me.ComboBox1.Value, sh.Range("1:1"), 0) Me.ComboBox2.Clear For i = 2 To Application.CountA(sh.Cells(1, n).EntireColumn) Me.ComboBox2.AddItem sh.Cells(i, n).Value Next i End Sub

[@alhassanmusah7242]

great work thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bharatprasad8450]

Good lesson to me, Thank a lot

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Ponder_The_Cosmos]

Thanks so much for this tutorial. It worked almost perfectly for me, but in my second combobox, the last rows value for selected column does not show. Does anyone know how to fix this?

[@crimcrow]

Thanks, Really helpfull :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Aryan.Vivhaan0111]

This video is very useful but when I m using this in my existing user form its showing unable to get the match property of the worksheet function class. Independent data is showing in combobox but when I using submit button this time the error is coming .can u suggest me for the solution.

[@Fazwaans]

Thanks for sharing your knowledge with everyone, Can you kindly enplane make video how to add Columns manually, e.g if i just want to add Column D, g, or Z. thank you

[@kailashsoni676]

Sir show row wise dynamically

[@ardeshiraqayi9976]

Please help me on this: What about the ComboBox on the worksheet? How can I simply make a dynamic range and then populate the ComboBox with it? Without a For Loop , of course

[@abdallahbelcaid3002]

Thank you so much ! and what about dynamic login form ?

[@PKAnExcelExpert]

Thanks for watching. Please watch below given video for login form: kzbin.info/www/bejne/pGisZmBsm89kobs

[@abdallahbelcaid3002]

@@PKAnExcelExpert thank you sir

[@abdallahbelcaid3002]

@@PKAnExcelExpert Sir I got an error in the function match what is the solution please help me is my final project ?

[@Learner566]

How to vaildation combobox value if when change the value by keypress

[@Yorumcu63]

Nice Video

[@sdesilva4728]

Thank you, it helped a lot...

[@barisersoy9784]

Thank You!

[@PKAnExcelExpert]

Thanks for watching

[@dashyi97]

Thank you for the very useful tutorial sir. May I ask how can I add a Clear button to the userform for the dynamic list in combobox? I seem to have an error with the Match property of the worksheet function when I use my usual code for Clear button. Thank you sir

[@henokayele8497]

wow your teaching is best! but i need some help of you how to code in vba not i worksheet this code please tell me you captured on worksheet but i want to code in vba.............eg:- combobox1 ("subject").........Dynamicaly in combobox2 = Biology.....physics.....etc

[@keranicat2127]

please help me "run time error 5" invalid procedure call or argument *** For i = 2 To Application.WorksheetFunction.CountA(sh.Cells("1,n").EntireColumn)

[@daljeetsingh1231]

I have 2 Dropdown List with the same options (Included and Excluded) in different sheets. If I select " Included" in one dropdown list, it should also select "Included" on another dropdown list and vice versa. I am new in coding please help me out to crack this.

[@vidyatutorials113]

Sir please tell me best book for VBA for beginners

[@marcosbertozzo3193]

Thanks a lot!

[@PKAnExcelExpert]

Thanks for watching

[@pietrogazzera5733]

Bravo!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ktamilarasan17]

Thanks a lot!!!!!

[@PKAnExcelExpert]

Thanks for watching

[@gautamgarde344]

Hello sir Sir please upload a video that's also contains the add items to dependent dropdown list.

[@AamirSaeedTajalli]

hello, wornderful tutorial.. Love your command over Excel and VBA. I have one question. What, if i want to display the first item of the 2nd category list depending on the the main category chosen above? kindly explain.

[@mjcomputershimatnagar]

Sir I want edit form by name search box

[@TheNewLifeTech]

Thank you so much for this wonderful video, can I apply this my another userform, please guide me.

[@SongsForSoul_ID-tr3cs]

i use thi script,but when i input an error occur, can you help me?

[@VijayKumar-zd7ou]

Sir how to be same condition apply ActiveX control without userform how to be possible

[@sameer_ansari5434]

Excellent work @PK: An Excel Expert, i want to extract data based on dependent drop down. i have prepared simmillar dash board using simple slicer, but i want to make a user form and extract data while i am gradually applying the filters with dependent dropdown. please help me with some guidance. an explaination would be more than i could ask. NIce work sir.

[@MohAboAbdo]

Thanks ... Thanks.

[@PKAnExcelExpert]

Thanks for watching

[@Design360]

*_Dear Sir, I am Md. Alamgir Kabir from Bangladesh. Thank you so much for your valuable tutorial. It's the same as my requirements, but I have a small query, How to add a unique item to this Combobox. Please help me_*

[@manyoeur]

Dear Sir, how can we code if we have more sub categories?

[@alriyami09]

hi, friend, can you help me to design the data entry form for me how much your charges

[@engrmamun59]

I can help you during payment contact. (You can mail me : [e-mail]) with your requirement.

[@fanueltomas2269]

Very nice

[@alializadeh8195]

Thanx

[@PKAnExcelExpert]

Most welcome

[@clovissassine7947]

Friend, can we have something similar to that about having a plan for a call center where employees can schedule their breaks and lunch and personal? or do you have a link for such a video? appreciate your assistance, thank you.

[@PKAnExcelExpert]

Hi Clovis, I don't have such video ready as of now but I will definitely try to make such video very soon. Thanks for watching

[@clovissassine7947]

thank you very much, hope to get a notification once it is done, i believe its beneficial for a lot of people as well, keep it up, your doing a great job!!!

[@MohAboAbdo]

Thanks ... Thanks ... Thanks ...

[@hemendravakharia2502]

but after running the combo box how to enter data in excel sheet ???

[@pablosel3857]

You call a procedure that contains everything you want to do

[@upgradetechnicalskills3392]

Hi Good morning sir I have made one searchable drop down list. My question is if my data is X workbook and I want to create searchable drop down list in Y workbook. is it possible and how to do that? Can you help me on that

[@PKAnExcelExpert]

Hi Kurban, I will try to make such video very soon.

[@123DZDZ]

Hi PK, good job, but can you do the same and eliminate the duplicates , exp: if the month or the year is repeated twice or more, it won't be shown on the comboBox, Thanks

[@surajbagkar9792]

nice one

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vonandrewronquillo5708]

What is abilabil?

[@dursunn]

how can I do this in python?

[@hasanthidevendra7049]

can yo give solution to show it on user form as list instead of showing it on excel sheet

[@abdihassen9102]

unable to get the mach property of the WorksheetFunction class, how can I solve that please

[@acespere]

how?? please.. anyone? followed above but encountered error.. help

[@PKAnExcelExpert]

Hi, Please send me your excel file along with the error snapshot on [e-mail].

[@Akash_with_GSD]

@@PKAnExcelExpert same problem

[@tors-a4808]

Great tutorlia. However my c=application.worksheetfunction,match(me.combobx1.value,sh.range("1:1"),0) geta an error saying that "unable to get the match property of the worksheet function class" I don't understand as I have completly copied your code.

[@abdallahbelcaid3002]

Did you find the answer ?

[@dhavaldaraji4]

I am also observed same error . please help me

[@jamilurrahman4328]

Thanks nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pankajhiralalpatel4454]

Sir I have an excel sheet, column A has dates and column B to J has other data. I want to create a combobox which shows those months which first date to end date available in Column A . Thanks in advance Please help me

[@AamirSaeedTajalli]

hi, did you get solution to this? can you plz explain what do you mean by "which shows those months which first date to end date available in Column A"

[@mrtechguru341]

sir please tell me how to make Double dynamic list in Combobox with coding please sir reply kar na !

[@abdihassen9102]

Thank you for your replay, it was my mistake

[@LearningWhileHavingFun]

hi thank you so much great video im having a run time error with this code n = Application.WorksheetFunction.Match(Me.txtSupervisor.Value, sh.Range("1:1"), 0)

[@dhavaldaraji4]

I have same problem

[@vigneshwarank529]

Well and good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ModernPindawale]

Sir excel main MISS expert person Kon hota hai. Or isme Kiya Kiya aata hai excel ka

[@VijayKumar-zd7ou]

Sir without combo box how to done

[@michaelconnors9906]

My range is in a column, not in a row. It begins in E8. I added a declartion or RNG as Range, Set rng = Range(Range("E8"), Range("E8").End(xlDown)) I kept Me.ComboBox1.Clear I rewrote the next line as For i = 8 To Application.WorksheetFunction.CountA(ActiveSheet.Rows(8)) I changed the 1 to a 5 in this line of code. Me.ComboBox1.AddItem sh.Cells(i, 5).Value Here's the full code. I hope it helps you set the range if it is other than 1:1 Private Sub UserForm_Activate() Dim sh As Worksheet, rng As Range Dim i As Integer Set sh = ThisWorkbook.Sheets("Sheet1") Set rng = Range(Range("E8"), Range("E8").End(xlDown)) Me.ComboBox1.Clear For i = 8 To Application.WorksheetFunction.CountA(ActiveSheet.Rows(8)) Me.ComboBox1.AddItem sh.Cells(i, 5).Value Next i End Sub

[@bosmanpm]

Hi. I used your changed code to my case. My range is also in column but start in B7. I changed yu code to: Private Sub UserForm_Activate() Dim sh As Worksheet, rng As Range Dim i As Integer Set sh = ThisWorkbook.Sheets("Urlopy") Set rng = Range(Range("b7"), Range("b7").End(xlDown)) Me.ComboBox1.Clear For i = 7 To Application.WorksheetFunction.CountA(ActiveSheet.Rows(7)) Me.ComboBox1.AddItem sh.Cells(i, 2).Value Next i all is fine, but I have more than 30 rows. This code shows me only 30 firsts rows. Last ten aren't visibility! How solved it? Any ideas? Ps. You have declared : rng As Range -> Set rng = Range(Range("b7"), Range("b7").End(xlDown)) Why? Where is it in solution?

[@VijayKumar-zd7ou]

Sir, can we will do this condition on sheet ActiveX control combo box on sheet without user form in excel please help and give me sample file on my email id

[@redareda2872]

you re the bt

[@AamirSaeedTajalli]

Seems, SIR dont like or dont get time to REPLY here :)

[@PKAnExcelExpert]

Hi Amir, sorry for the late reply. You can use listindex property of combobox. It starts from 0.

[@AamirSaeedTajalli]

@@PKAnExcelExpert Thanks a lot dear. I tried it on form level but not working.

[@AamirSaeedTajalli]

Boss, just now tried again. In excel at form level, i used code "ComboBox17.Text = ComboBox17.ListIndex(0) and getting "Type mismatch error" Data is populated absolutely correct. Just want to select and display first item in list of combobox17

[@mrtechguru341]

Plz bro reply me

[@MrPACO0508]

Thank you for the very useful tutorial sir. May I ask how can I add a Clear button to the userform for the dynamic list in combobox? I seem to have an error with the Match property of the worksheet function when I use my usual code for Clear button. Thank you sir

[@nileshpawar7436]

Same here... Getting error same error.. compile error

[@mhareandeancojuangco9734]

Same here..any resolution please

[@MohAboAbdo]

Thanks... Thanks... Thanks.

[@PKAnExcelExpert]

Thanks for watching