Date is not inserted properly in Textbox (UserForm)

Good day
I am trying to populate a UserForm with the right date format and I guess my method is not doing this properly.

I have a UserForm with the following code:

Please Login or Register  to view this content.

My d is a module

Please Login or Register  to view this content.

I have another Userform set as a calendar2 that if the user presses down on the textbox that it will call the Calendar2 and the user will be able to select the date required.

I have tried changing the .text to value but nothing, the date always adds itself has 2014/06/30 in both textboxes.

What am I doing wrong? maybe my change_event but this should not be triggered at the UserForm_Initialize right?

What isnt' being populated properly?

My Textboxex (TextBox4 and TextBox5)

Problem seem to be here:

Please Login or Register  to view this content.

Everytime I populate my Userform and, let's say my date in my Range("Q" & ActiveCell.row) = to 2014/07/07, it will populate in my UserForm as 2014/06/30.

Here is a workbook,

If you D_Click on the W8486-123456 you will see that the date is not even the same as the information on sheet

VBE - UserForm (frmamendment)

Date.xlsm

Remove this code.

Please Login or Register  to view this content.

Bingo, Thank you Norie

Yes but the problem with this is that if the user inserts a new date the format will not be my yyyy/mm/dd but will reset to it's original format: mm/dd/yyyy.

That is why I had the Change_Event for the textbox format to be yyyy/mm/dd.

Is there a way to make it that all my textboxes date value = yyyy/mm/dd?

frmCalendar2 =

Please Login or Register  to view this content.

Don't use the Change event, use another event eg AfterUpdate, Exit.

This will work too

Once again thank you Norie