Userform adding text box

[Marchenrysaad]

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.

[MarMo]

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

I uploaded the adjusted file.

hope this helps.

[Marchenrysaad]

Dear MarMo

A sincere thank you for taking the time to help. However, i was able to add a date textbox like you did.

But it is not enough because I want the "Date" box to be also used in the other features. When i search for a previously entered client, I couldnt get the date to show in the form and to be edited.

And as a final request, is it possible that the date value be inserted in the sheet right after name? Without ruining the code.

Thank you again and any help would be much appreciated.

[MarMo]

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

[Marchenrysaad]

Exactly what i need!

Thank you very much Marmo

[Marchenrysaad]

Hello Mr MarMo

I was just checking the file again. And I think there is something wrong.

First, what is the format of the date that should be entered?

Second, If i type June 2018, it works. But then if i want to amend it, i type november 2018, it changes to 22-june-1905 for example.

Try amending a date and you will see it.

Sorry again but if i can get this to work i am done!

[Marchenrysaad]

I was just checking the code again and I think the amend option is not working. I have a previous version V4 without the date column and it works perfectly however the amed no longer works in V5 (After adding the date)

[MarMo]

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

[Marchenrysaad]

dd/mm/yyyy is good

or

mmmm dd yyyy (July 28 2018)

I added some comments in the active sheet not in the code

thanks again!!

[MarMo]

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