Userform adding text box

Hello all,

I have a userform that works perfectly and has several features.

I want to add 1 textbox i forgot about.

However i am having a tough time doing so because there are several automated cells and formulas with for and while loops.

When you see the code you will understand what i mean. I tried shifting all text box names by 1. For example Textbox2 becomes Textbox3 and 3 becomes 4 .... And then add a new Textbox2 to integrate into the code and edit the range of while loops from (1 to 11) to (1 to 12).
However the code is unstable and not working.

I simply want to add 1 textbox called "Date" after "Name" and I want it to add it to the excel sheet of course.

Any help would be great.

This is for a client I have that might benefit from such a userform so I need it to be perfect and to submit it as soon as possible.

You could add a textbox after the Name, and adjust the code without changing everything.

I just added a textbox after the name textbox, named it TxtDate and adjusted the code slightly to add the value to column Y.
There are no major adjustments.
added a 5th val variable : val5 as a date

Dim i As Long, val1 As Double, val2 As Double, val3 As Double, val4 As Double, val5 As Date

and added the value to a cell in column Y.
I added code according to your code

    Cells(c.Row, 25) = val5

I uploaded the adjusted file.

hope this helps.

Made some small adjustments.
Pls try the userform and see if it meets your requirements.

In what format must the date be ?

mm/dd/yyyy
dd/mm/yyyy
other ..... ?

pls, upload the WB with the wrong data, and add comments pls in the WB
I'll try to look at it ASAP !

grtz

Amend button adjusted, and date format is still dd/mm/yyyy.
The amend code was not updated before, because i thought you where going to do this.

You'll find your new WB with adjusted code.
Pls test it and let me know if it works.

Kind regards