Error Capturing Date and Time Formats

Z

Zani

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Date in an overseas format 21
Excel does not accept text format! 0
How to add day to PWA 2016 date format? 0
Date Formats 4
Date format Workbooks Open 1
Date Format - simple question 1
Automatically displaying text in a form 8
Forcing a date entry format of dd/mm/yyyy 1

Top