Error Capturing Date and Time Formats

G

Guest

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 20
Date format Workbooks Open 1
Date and Time Formats in UserForms 2
Pasting a date to a cell from UserForm 2
Force users to enter a range of cell in dd/mm/yy hh:mm format 3
Validation on text input boxes on a form 11
Automatically displaying text in a form 8
Time format will not exclude seconds!! 3

Top