Excel VBA: date format in user form

Question

I have various text boxes in a user form with dates pulled from my worksheets, but all the dates are in US format (m/d/yyyy).

I'm using the ControlSource property to copy the date, e.g.:

ControlSource='SKU Data'!N2

Is there a way to reformat the dates so they appear as d/m/yyyy?

The dates in the worksheets are already formatted to d/m/yyyy.

Answer 1

Do it with Strings:

Sub dural()
    txt = "12/25/2014"
    a = Split(txt, "/")
    txt = a(1) & "/" & a(0) & "/" & a(2)
    MsgBox txt
End Sub