Excel VBA date reversed

[brianfosterblack]

I am using windows 7 and Excel 2007. In Ecel I have a form set up with a textbox to insert the date. I enter the date in the format 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 are my line of codes
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = Format(FrmApplications.TextBox1.Value, "dd/mm/yyyy")
Does anyone know how to correct this.

 

[Andrew Poulsom]

Welcome to MrExcel.

Try:

ActiveCell.Value = DateValue(FrmApplications.TextBox1.Text)

The DateValue function is locale aware (unlike most of VBA).

 

[brianfosterblack]

Thanks, this works perfectly. You don't know how many people I have asked who could not give me the answer and I got it within 60 seconds on this forum. Thank you very much