Date format changing

[luizmachado]

This code below was supposed to transfer 2 kinds of date data.
If I press "Hoje" (It means "today") ribbon, it shall transfer =Today() function to the date column, but I press the "Outra data" (It means "anoter date") ribbon, it shall transfer the date I want (07/02/15, as the print example) to the date collumn. However, when I enter with any "another date", it brings back to the US format (which is different than mine, brazilian). It should be dd/mm/yy (or dd/mm/yyyy), but it is making it mm/dd/yyyy. (I've already check column date format and it's the brazilian one)

I've already desactivated the autofill option, but it won't work. I think that if each row were independent, there would be no problem.

This is my code: (I know this is only a part of the code, but I guess I won't be necessary. I needed, I can post it here)

Please Login or Register  to view this content.

This is my workbook: (1st image shows the userform with all that options to fill this table below - date option is there. 2nd image is the problem happening, as you can see by the 1st image date value.)

[luizmachado]

Sorry, the data on date textbox is actually 07/02/15, not 02/07/15. I, accidentally, deleted the first image, needing to "create" another one and put the wrong data in it. Anyway, in the first image where you see "02/07/15", is, actually, "07/02/15" (that's how it's changing).

Forget it. I fixed!

[spitfireblue]

You can format the date using the below function...

Format(Date, "dd/mm/yyyy")

i.e. Format (DateBox.Text,"dd/mm/yyyy")

[luizmachado]

You can format the date using the below function...

Format(Date, "dd/mm/yyyy")

i.e. Format (DateBox.Text,"dd/mm/yyyy")

I tried it and it's giving me "Syntax error". I basically copy/paste on that code above.

Please Login or Register  to view this content.

[spitfireblue]

Like this...

Please Login or Register  to view this content.

What format is DateBox? You probably don't need the .Text

[luizmachado]

I tried it out, but it didn't work =/. I'm still getting the date format changed.
DateBox is a textbox on my user form. I tried without .Text and, as you said, it is not needed.

Like this...

Please Login or Register  to view this content.

What format is DateBox? You probably don't need the .Text

[spitfireblue]

Can you attach a copy of the workbook?

[luizmachado]

Here it is =)

Can you attach a copy of the workbook?

[spitfireblue]

Here you go. Your problem was that DateBox was coming through as text

Please Login or Register  to view this content.

[luizmachado]

It worked!!!!! Thank you =)

[luizmachado]

I was working till now, but it won't keep the "dd/mm/yyyy" format for every other sheet.

This is a part of the actual code:

Please Login or Register  to view this content.

[luizmachado]

It was working till now*

And this is a part of the entire code, if needed:

Please Login or Register  to view this content.

This is my workbook, if needed (larger than 1000kb): https://www.dropbox.com/s/i8gsssg89m...2016.xlsm?dl=0

[luizmachado]

Oh, sorry!
I forgot to write DateValue before the actual date.
It is, basically:

Please Login or Register  to view this content.