excel vba revers date

[adelvoira]

Hello,

In Excel I have a form with a Label caption link to date and the format is: dd/mm/yyyy which is the same as my format for dates as set up in windows. However when the form transposes this to the worksheet the date is reversed into the format mm/dd/yyyy.

Here is my line of code
label1.caption= date

thank you
​

 

[bugmonsta]

You can set the format of your date:

Label1.Caption = Format(Date, "dd/mm/yyyy")

 

[adelvoira]

You can set the format of your date:

Label1.Caption = Format(Date, "dd/mm/yyyy")

the same problem persist

 

[Fluff]

How are you putting the date into the sheet?