Date changing format when shown in a userform

[Diving_Dan]

Hi all,

I know I've had this problem before I can't remember for the life of me how to fix it.

I have a userform that displays data from a worksheet. It is one line of code that is causing me problems

Me.txtTsCsAcceptedOn.Value = ActiveCell.Offset(, 8).Value

The date is stored in the worksheet in the format of dd/mmm/yyyy but when it is shown on the userform is shows as mm/dd/yyyy when I would like it to remain in the same format as the worksheet.

Any help will be greatly appreciated as always.

Dan

 

[Akuini]

Try:

Me.txtTsCsAcceptedOn.Value = CDate(ActiveCell.Offset(, 8).Value)

 

[dmt32]

Try using the Range.Text property which should return what you see in the cell rather than its underlying value

Me.txtTsCsAcceptedOn.Value = ActiveCell.Offset(, 8).Text

Dave

 

[Diving_Dan]

Just tried that and it gave me the same answer, showed as mm/dd/yyyy still

 

[dmt32]

Just tried that and it gave me the same answer, showed as mm/dd/yyyy still

which suggestion does this refer to?

Dave

 

[Diving_Dan]

Sorry just seen your reply Dave, your option worked. Thank you

 

[dmt32]

Sorry just seen your reply Dave, your option worked. Thank you

glad we were able to help & appreciate the feedback

Dave