Date changes from "dd/mm/yyyy" to "mm/dd/yyyy" from userform to worksheet

[Diving_Dan]

I'm having problems with a userform I fill in to add data to a worksheet and also to view data on the worksheet.

This is one of the lines of code I am using to put the code to the worksheet that is causing me problems (I have several fields with dates).

Activecell.Offset(,1).Value = Me.textStartDate.Value

I thought i'd be able to put Format at the start of the code with "dd/mm/yyyy" at the relevant place but that didn't work so i'm out of ideas.

Any help is always appreciated

 

[Logit]

What formatting the cell ahead of time ?

 

[dmt32]

Hi,
try coercing your textbox text to date

ActiveCell.Offset(, 1).Value = DateValue(Me.textStartDate.Value)

Dave

 

[Diving_Dan]

Thanks Dave, just what I needed.

 

[dmt32]

Thanks Dave, just what I needed.

welcome but do be aware, line of code will error if no valid date exists in your textbox

Dave

 

[Diving_Dan]

welcome but do be aware, line of code will error if no valid date exists in your textbox

Dave

I found that straight away so added an If in the line above