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
Bookmarks