duplicate userform fields and send to spreadsheet depending on listbox1.listcount

[AndyJM87]

Firstly, hello to all. I am a newbie here and also a newbie in excel.

I need some help from you please. I have been tasked in work to create the spreadsheet with a userform to input all data.

On the userform I have a listbox for vehicle numbers. What I need to do is copy all of the data from the userform to the spreadsheet row by row depending on the number of items in the listbox.

For example:
If I have 10 vehicle numbers added the the VRN listbox, I need the whole userform to copy 10 times.
If I have 15 vehicle numbers added in the VRN listbox, I need the whole userform to copy 15 times.

Each time it copies it needs to go to the next row,

I have included some screen prints to hopefully make it a bit more understandable. I have had to block certain things out due to the nature of my work.

Any help appreciated

​

 

[My Aswer Is This]

We need to know exactly what Userform control values go to what Range on the sheet.
Saying just copy the entire Userform 15 times does not provide exact details.
And looking at your image does not help me.

Like you need to say Textbox1 value copy to column 3 first empty row
Textbox2 value copy to column 4 first empty row
And on and on

And looking at your image is very hard for me to see exact details