Creating a Userform

[Jeezan Ahmed]

I need to create a VBA code for a user form which includes a Combo box a List Box and 3 Buttons. One button will be used to unload the User form and another button to add the data selected from the combo box to the next empty row in the list box and another button to add all the data populated in the List Box to the Excel worksheet. The combo box as well as the List box are Multi columned and they contain 3 columns.

The data to the Combo box needs to be added dynamically everytime the user form loads also the combo box needs to be able to auto complete.

 

[sijpie]

Which sheet & columns is the source for the combobox?
Which sheet does the result need to go to?

Why do you want two different types (combobox & listbox)? Why not make them the same type?
Do you want a way to remove a line from the 2nd box? (the user could have made a mistake in adding it)

Form would look something like this: