Populate userform textbox with date taken from cell in 'dd/MM/yyyy' format

[entropia_gr]

Hello,
I want to fill a userform textbox with a date taken from a cell. The date in the cell is in 'dd/MM/yyyy' but the date drawn from this cell into the textbox comes always as 'MM/dd/yyyy'. Any suggestions would be highly appreciated as I have been wasting tons of hours on that issue.

Text_checkin = DateValue(Sheets("Data").Range("Data_St").Offset(Trgt, 3).Value)

 

[Akuini]

Try using Text property:

Text_checkin = Sheets("Data").Range("Data_St").Offset(Trgt, 3).Text

 

[entropia_gr]

Thanks a lot! It seems to work

 

[Akuini]

You're welcome, glad to help, & thanks for the feedback.