Excel glitch? (Userform Textbox = Format, "Date")

[Excelnoub]

Good day,
I just want to point out a small glitch or am I doing something wrong?
I have the following code that makes my Textbox3 from my Userform add the date format to “YYYY-MM-DD”

I came across yesterday a weird date glitch... When I selected 2013-11-12 it gave me 2013-12-11 but this means December 11, 2013 I want November 12, 2013. Today it works perfect and it writes down the code in accordance to the code, but still doesn’t take the November 12, 2013... Why?
Userform Code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Note: Plus my Column is set to Custom "YYYY-MM-DD"

[Norie]

How exactly are you putting the date in the textbox?

[Excelnoub]

Because I have multiple date entries within the same userform, I have multiple calendars set up (total 3), the reason why 3, is that I am able to control multiple date entries to specific textbox without adding dates to multiple textbox... each textboxs is triggered by it's own calendar.

So for this textbox3 I have frmCalendar2.Show that pop-up and I can select my date from this calendar form and on selection it transfers the info to my textbox3.

[Norie]

How is the date transferred to the textbox?

Have you considered losing the change event and directly putting the formatted date into the textbox from the calendar?

By the way, you could easily handle multiple date entries using a single calendar form.

[Excelnoub]

For the calendar I had some trouble adding multiple entries to different textboxs. If I had for example Textbox3 and textbox4 with date entries... I would add the code:

Please Login or Register  to view this content.

But it would add the date in both textbox, I know i'm missing something to use only one calendar but that would be another thread

_______________________

I have the following calendar2:

Please Login or Register  to view this content.

Then in my userform I have the following code (not all code but only for Textbox3)

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Problem is that if November 12, 2013 is selected it shows as 2013-12-11 but the code sais that the format is YYYY-MM-DD... I need it to show as November 12, 2013 and not December 11, 2013...

But November 13, 2013 works perfect... I am so confused

[Norie]

So, why not try what I suggested?

Instead of using the textbox's change event to format the date use the code in the calendar form to put the already formatted date in the textbox.

Please Login or Register  to view this content.

[Excelnoub]

Here Is a test you just have to select New Entry (Command Button).

Datetest.xlsm

[Excelnoub]

Got it I have changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

this fixes it :D

Thank you Norie :D