userform with looping code

Try this workbook.

Because VBa cannot handle an array of controls like full VB you have to be more careful with your control names and their layout.

I have corrected some names and positions in this workbook, the code will fail in your originally posted workbook.

I have left my original formula in this workbook, change the date in B40 to see how it works.

There is also code that can be used to populate your userform on activation, this could possibly be used to call a similar previous order that might be faster to amend and give a new date than fill in the lot from scratch.

Is this what you are after?