Excel VBA Forms Part 6 - ComboBox Controls

[@mattvba25]

As it has already been said multiple times, your work here with these tutorial videos on VBA is absolutely remarkable and has no parallel on the internet! (You killed me at 18:50, "...we won't talk about those...").

[@WiseOwlTutorials]

Ah thanks Matt! I appreciate you taking the time to leave a comment and thank you for watching!

[@acequantum2850]

I scoured the internet for HOURS yesterday trying to understand all of the jargon involved in populating lists for combo boxes, and it would have been SO much easier if I had just clicked on this video. Thank you so much for making these!

[@WiseOwlTutorials]

Happy that you found us eventually! Thanks for watching and taking the time to leave a comment!

[@cukhoainuong]

@@WiseOwlTutorials it's better if the video time reduces around 15min - 20min

[@cukhoainuong]

@@WiseOwlTutorials your lessons are very detailed, but take long time

[@divyal5852]

Andrew!!! Can't stop thanking you for the wonderful series on forms.

[@JManaley]

Hi Andrew, your tutorials are the best of any subject I have experienced, simply amazing, I find myself going back time after time. I can't thank you enough :-)

[@WiseOwlTutorials]

Ahh Jeff that's lovely to hear! Thanks for taking the time to leave a comment and for watching!

[@sumardjo]

wow is complete to learn thank youtube and wiseOwlTutorials i have practice to file sample thanks a lot

[@WiseOwlTutorials]

You're very welcome Rusdi, thanks for watching!

[@pradeeprawatvlogs8358]

I came across your channel today and the content is super awesome thanks for this by heart. Thank you so much

[@MagicOfMushrooms]

Thanks for all you do!!!

[@WiseOwlTutorials]

You're very welcome and thank you for watching!

[@rulingkid]

Thanks a lot for this, Your channel is the absolute best.

[@chrisfekete6101]

Hi Andrew: Thank you for the series. A quick question, why on 40:15 does the description show up instead of the certificate number. It shows "Grown up" instead of the certificate number 18. You had already had TextColumn Property to -1.

[@leeeric6292]

40:14 but the combobox still show one column only after you click to select the two columns in its drop down menu, is there a way the combobox can show two columns? Thanks.

[@WiseOwlTutorials]

Hello! If you want to show the value of multiple columns after selecting an option from the list you can concatenate the values of multiple columns as described in multiple answers on this post stackoverflow.com/questions/41574467/how-to-display-second-column-in-combobox-after-selection I hope it helps!

[@leeeric6292]

@@WiseOwlTutorials Thanks and I have gone through the link you suggested, I tried to put the code " filmcertificate.text = filmcertificate.column (0) &" "& filmcertificate.column(1) " in the Afterupdate event of the combobox, however error is found with highlighted yellow, and still show one column only...

[@WiseOwlTutorials]

@@leeeric6292 I'm sorry I don't know then. If it's vital that you display multiple columns after selecting an option it might be easier to use a ListBox rather than a ComboBox

[@thanhthiet1033]

Hi Andrew, could you please create a new video tutorial on how to create a searchable combobox from the keywords the user entered and suggest searched results to display a dropdown list with the combobox_change event in the VBA userform. Thank you very much.

[@sagarkumarsubudhi261]

Thanks for your videos.. one question, can we pass one object from a sub procedure or function to a combo box?? TIA.

[@shannonmcmahon1485]

Thank you for your great videos! I am trying to use a userform where the day, month and year are selected from combo boxes and then the data on the sheet is searched for between the dates selected. How would I go about doing this? I have got the combo-boxes set up and the code to search between specific dates but I can't get it to search using information the user has selected

[@matthewhogan7441]

Is there a way to use range.advancedfilter to populate the combo box list with distinct values?

[@WiseOwlTutorials]

Hi Matthew! It might be easier to use Excel's UNIQUE function like so: Me.ComboBox1.List = WorksheetFunction.Unique( _ Sheet1.Range("A1", Sheet1.Range("A1").End(xlDown))) I hope it helps!

[@YvesAustin]

Always great to view your videos; clear and concise. One quick question: I am attempting to format my combo box value and want to center horizontally and vertically. I was able to do the firs but not the latter (it is at the top of field, not centered); I checked in the properties section, and haven't found anything relevant. Do you have a trick to perform that by any chance? Thank you so much!

[@chahineatallah2636]

its giving some strange error numbers, am not able to find the issue, is it a bug or something? any advise guys Private Sub USARATING_Click() category.Clear category.RowSource = Sheet1.Range("USA").Value End Sub and the debug is pointing to category.clear, i name my combobox category

[@WiseOwlTutorials]

Hi! Make sure your combobox doesn't have its RowSource property set.

[@fightsportsuk6760]

This is awesome. Andrew your work is brilliant. I have a question. For the loop to work over one frame you have entered the code. For each ctl in Filmdetailsframe.controls, however say if you had 3 frames and you only wanted to loop over two frames. You would avoid me.control, however how would you add the additional frame control. Any help appreciated. Mark.

[@robhaman2546]

Andrew, best learning venue I've seen for VBA. How would one go about adding information to different lists based on the selection in a combo box. I would like to use the same form to populate the lists. For example; if the user selects Blue in the combo box, the information added in the form would be entered in the Blue list. Greeen, the green list, etc.

[@robhaman2546]

That is the method I was thinking of. Very new to this so thought I would have you verify my thoughts.

[@bengoldfinch8996]

Does a combo box accept only vertical lists I tried a horizontal one and it only shows the first item

[@bengoldfinch8996]

Ive got it working now I uses application.worksheeyfunction.transpose to get it to work

[@edrianmanuel6527]

Hi Andrew, Thanks for form Tutorials, more videos form Tutorials pls :D i have a problem regarding last part of the video ActiveCell.Offset(0, 0).Value = cboEquipmentDetails.Column(0, cboEquipmentDetails.ListIndex) ActiveCell.Offset(0, 1).Value = cboEquipmentDetails.Column(1, cboEquipmentDetails.ListIndex) this code is working we dont have problem with this but what if i forgot to input combobox details this showing error, after i forgot to input combobox run-time error '381': could not get the column property.invalid propery array index please check. :D TIA

[@nickorozco4301]

Can you make the videos 16:9?

[@krn14242]

Thanks.

[@yeuduongtamhuong]

Private Sub certificatecombobox_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) If certificatecombobox.Value = "" Then certificatecombobox.BackColor = rgbPink labelcertificate.Caption = " Choose Certificate" Cancel = True End If End Sub why It does not work?

[@yeuduongtamhuong]

i want to check combobox if combobox is empty. it not error, but it aslo don't run(forcible). Sorry about my english skills.

[@PachAvin]

Thank you very much for your fantastic tutorials, Andrew. 30 minutes of your video saves hundreds of hours of exasperating google searches, frustrated face-palming and strenuous rote learning. I am consistently applying the techniques I learned here and still continuing with my learning. I have a few queries related to the comboboxes. I have accomplished a few of the objectives but I am not sure whether those are the best methods. Could you please review and give your comments. Query 1: I want to start typing in FilmCertificates combobox and immediately the suggestions for auto complete should appear inside the combobox. I accomplished it the following way. Please advice if there are better methods. Private Sub FilmCertificate_BeforeUpdate (ByVal Cancel as MSForms.ReturnBoolean) Dim inlist as Boolean, i as long For i = 0 to FilmCertificate.ListCount-1 If FilmCertificate.List(i) = FilmCertificate.Value Then inlist = True Next I If inlist or FilmCertificate.Value = Empty Then FilmCertificate.BackColor = rgbPink FilmCertificate.SelStart = 0 FilmCertificate.SelLength = Len(FilmCertificate.Value) Cancel = True End If End Sub Query 2: Imagine FilmCertificate combobox is at the top, above the FilmName textbox. The FilmName textbox remains disabled. My aim is to enable typing in FilmName textbox only if I choose something in the FilmCertificate combobox and tab away. If I try as follows, the cursor skips the FilmName textbox and sets focus in FilmGross textbox Private Sub FilmCertificate_BeforeUpdate (ByVal Cancel as MSForms.ReturnBoolean) FilmName.Enabled = True End Sub However I was able to accomplish this through KeyDown event as follows. Again, I am not sure if this is the best method. Please advice whether there are better methods. Private Sub FilmCertificate_KeyDown (ByVal KeyCode as MSForms.ReturnInteger, ByVal Shift as Integer) If KeyCode = 9 Then FilmName.Enabled = True End Sub Query 3: UNSOLVED. I am helping someone who uses Arabic language on user forms. FilmCertifcate has its dropdown arrow on the right. When the language is English, the text is left aligned and dropdown arrow is on the right. For Arabic, this has to be the opposite.i.e. dropdown has to be on the left side and the text has to be typed from left to right. Is there a way to achieve this?