Hi

I have a textbox with the code below on userform 1 & 2 showing the current date in DD/MM/YY, this date is copied from userform 1 to userform 2 and finally onto an excel worksheet. However, on some occasions the format changes to MM/DD/YY. Is there a way to force the date format to DD/MM/YY

' userform phase2 
Private Sub UserForm_Activate()
Application.Run "StartTimer"
TextBox3.Text = Format(Now(), "DD/MM/YY")
End Sub

' userform pt2
Private Sub CommandButton1_Click()

PT2.TextBox9.Value = PHASE2.TextBox3.Value


Application.Run "StopTimer"
Unload Me
End Sub