Excel vba dropdown/combo box

[ronakinuk]

Can you please help me how to select multiple values from an excel drop down /combobox.

I have a userform with a combobox.

whenever user selects some items from that combobox, and press submit, the value gets filled in a particular cell in another sheet.

Is is possible to select multiple value from that combobox?

thank you.

[ADezii]

1. In Excel, you can only select Multiple Items from a List Box, NOT a Combo Box.
2. Assuming you have a List Box named ListBox1 on a UserForm:
   

   Dim intCtr
    
   For intCtr = 0 To ListBox1.ListCount - 1
     If ListBox1.Selected(intCtr) = True Then
       MsgBox ListBox1.List(intCtr)
     End If
   Next intCtr

   will return the Items selected individually.