UserEntryForm Dependable multiple selection and entry of multiple rows at the same time


New Member
Dec 7, 2016
Hello everyone,

I would like to create a user entry form that would create multiple rows in the Worksheet in the following way:

  • The user form would have 3 TextBoxes, 2 ComboBoxes, one multiple selection ListBox and a button for the entry

  • An user of this form would write in the random infromation in the first 3 TextBoxes.
  • Then he would choose one item from the 1st ComboBox.
  • The 2nd ComboBox would be dependable on 1st ComboBox, so the the list would change according to the selection in the 1st ComboBox.
  • When both selections are made, the multipleselection ListBox would show all the Items (Item1, Item2, Item3, etc) also dependable on the selection that was made in previous ComboBoxes.
  • The user would then tick all the necessary Items in the ListBox
  • When the user presss the button on the User entry form, the information would be inserted in the excel worksheet in the following way:
o Information in the 3 textboxes would display in columns A, B, C
o In the column D there would be information that was chosen in ComboBox1
o In the column E there would be information that was chosen in ComboBox2
o Based on the number of selected Items in ListBox, Excel would create that many rows (if the user ticks for example 4 Items 4 rows would be created. Columns A, B, C , D, E would have the same information written in all 4 created rows. The rows would only differentiate from each other based on the selection of the Item in the ListBox, which would be displayed in column F.

I would also like to write the dependable lists for selection in ListBox and ComboBoxes in a seperated worksheet. This would make further editing of the List much easier than to have it written in macro.

Could someone please help me / guide me on how to do it, because I don't have yet much experience working with vba.

KR and thank in advance ;)

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics