Well for umpteenth time I have a question,
I would like the user to be able to type 041505 hit enter or tab and in the
user form now show the date as o4-15-05.
The following is what I have attempter thus far. Thank you!
Private Sub txtDate_Enter()
txtDate.Value = Format(Me.txtDate, "")
End Sub
Private Sub txtDate_Exit(ByVal cancel As MSForms.ReturnBoolean)
txtDate.Value = Format(Me.txtDate.Value, "dd/mmm/yy")
End Sub
--
Though daily learning, I LOVE EXCEL!
Jennifer