VBA Date formatting issue

[rickbanny]

Hi Guys

I'm having a mare getting Excel to format a date correctly. I have a user form that pops up when the workbook is opened and the user picks a date. The text box value will always store the date in the correct format i.e. dd/mm/yyyy but when the date gets put into the sheet it gets reformatted to mm/dd/yyyy but only if dd < 12 - if dd > 12 then the date gets formatted correctly!!!!!. The only way I can get round this is to format the destination cell as text but this prevents me form using it in a calculation.

extract of code:

Range("M3").Activate
ActiveCell.NumberFormat = "dd/mm/yyyy"
Let Range("M3").Value = TextBox2.Value

Help!!!!

[Kaper]

I don't have english version of excel handy, but probably problem is generated by conversion of value in a textbox (type text even if it looks like date) into a cell value. May be using explicit conversion would be enough:

Range("M3").Value = cdate(TextBox2)

or

Range("M3").Value = DateValue(TextBox2)

[rickbanny]

Thanks Kaper - that seems to have done the trick