Merging MonthView & DTPicker Valuie into one cell

[adam2308]

I have a user form on the attached example and on the form i have 'Month View' calendar control and 'Date/Time Picker'.

I am trying to merge the valuses of both controls into one cell. I have tried doing this with the following code:

Private Sub CommandButton1_Click()
    Range("B2") = Format(MonthView1.Value, "dd-mm-yyyy") & " " & DTPicker1.Value
    Unload Me
End Sub

When doing this though, the cell that the form puts the date/time into formats to mm-dd-yyyy. I don't understand why though as the cell is formated as dd-mm-yyy and i have also tried to add this into the code above but still displays mm-dd-yyyy.