Save all UserForm data for multiple rows

Hi guys,

How can I add/amend my code, that for each new ListBox data row, ALL other UserForm data is also saved to my sheet?

Detail:
I have a simple UserForm with a Description/Detail section, and a Line Item section. There can be multiple Line Items, but only one Description/Detail section per UserForm.

When one saves the UserForm, it saves/creates a line for each Line Item. As many line items as needed. BUT, here is my challenge:

How can I have the rest of my UserForm data save for each line as well? i assume a type of loop? But how?

I appreciate your help guys!

See my sample workbook.

you simply move the textbox code into the loop like this :

Please Login or Register  to view this content.