Hello everyone,
I would like to create a user entry form that would create multiple rows in the Worksheet in the following way:
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![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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 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