There is no built in validation. You have to use events such as Exit or
AfterUpdate where you place your code to validate the entry.

--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Could someone please tell me how to validate a date entered on a user form
and also how copy in the appropriate format back to the worksheet. On the
worksheet the existing dates are in format May-14-97 by setting it in a
custom format. These were entered manually.. Now the worksheets fields
encompass more of the worksheet so it necessitated a user form for ease of
viewing/changing/adding/deleting. The date when entered is not based
necessarily on today's date.. as most dates are in the past.. since archived
information is being consolidated into a spreadsheet so it can be found in
one spot.

Thanks