Error Capturing Date and Time Formats
 

Hi

I have a set of UserForms capturing all types of information and returning
the data to a spreadsheet. I have finally managed to get dates and times to
format correctly however I now need to find out how to capture any errors.
ie I want users to be forced to enter dates in dd/mm/yy format and hh:mm
format for times, if they don't enter in this format how can I capture the
errors and get them to go back and enter in the correct format?

Any help very much appreciated, otherwise I wont get to bed tonight!

--
Zani
(if I have posted here, I really am stuck!)

Error Capturing Date and Time Formats
 

Maybe using a calendar/date control would be better.

Ron de Bruin has some tips/links at:
http://www.rondebruin.nl/calendar.htm

Zani wrote:

Hi

I have a set of UserForms capturing all types of information and returning
the data to a spreadsheet. I have finally managed to get dates and times to
format correctly however I now need to find out how to capture any errors.
ie I want users to be forced to enter dates in dd/mm/yy format and hh:mm
format for times, if they don't enter in this format how can I capture the
errors and get them to go back and enter in the correct format?

Any help very much appreciated, otherwise I wont get to bed tonight!

--
Zani
(if I have posted here, I really am stuck!)

--

Dave Peterson