Excel VBA ActiveX Series #4c Combobox - Alternate ways to fill combobox, 2+ columns in Cmb

More ways to fill and use a Combo box! See previous video for combobox basics. A Combobox is basically a drop-down list that you can type onto, a combo of the Textbox and a List.

Fantastic Developer Tools:

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[tutsecret]

Is there a way to make the dropdown list drops automatically without so many clickings. If somebody has too many data to insert, it causes a lot strain on the hands to make selection over and over. People has disability, injury on the wrist, the less clicks the better and use short cut keys.

[barryslatcher]

Hi Dan,
I am looking to perform a similar task that you have shown here. Rather than using the list method of filling a combobox or dynamic range method using offset, I would like to fill a combobox with 2 columns using a table. When I create a table and try to put the table name in the listfill range under combo box properties, it rejects it. Is there a way to perform the task I am trying to accomplish.

[vndril]

Thanks that explained alot. One thing though, do you have to make a new ComboBox for each row or can you use the same one over and over again down the rows?

[geoffroy]

Bonjour,
BRAVO!
Je trouve votre vidéo très bien car je ne comprends pas votre langue mais j'arrive à comprendre votre vidéo. :)
J'aimerais mettre une combobox dans un userform mais qui insère 5 colonnes sur une autre feuille excel en A2 et à la suite,  quand j'ai sélectionné mon choix dans la combobox
comment faire?
merci

[TheRapidhome]

Can any body direct me to the fallow up video to access the second column? I would really appreciate it