Validate

socko139

Registered User.
Local time
Today, 17:43
Joined
Feb 22, 2001
Messages
25
I've been struggling through this one and keep getting errors with my code. I was hoping if anyone has ever written or can help me write the code to validate a time. I need to validate if a user entered in say for example 5:55 AM or 10:10 PM. (I'm doing the validation on a text field in Microsoft Excel and therefore need code to do this) I think it should be easy, but Im running into problems...any suggestions?
 
Use the IsDate() function. It works for time as well since time is stored as the decimal portion of a date.
 

Users who are viewing this thread

Back
Top Bottom