Populate from Combo Box

  • I am trying to populate multiple cells from a combo box. I would like one of the options in the combo box to be a "list all". When this is chosen, I would like Excel to list in other cells all values contained in the combo box.

    Any help??


  • Suppose your combobox is called ComboBox1 and you have a command button to enter the data. Suppose you wanted to put these values in column A of "Sheet1"

    In your UserForm Module, you should have:

    Of course, you can modify code to suit for Range, Control names, etc...
    Let me know if you need help with that!

    Hope that helps!


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!