Take a look at http://www.xldynamic.com/source/xld.QDEDownload.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jennifer" wrote in message
...
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