Catch a wrong value
One way:
Debug.Print IsDate("09:95"), IsDate("09:55")
or
Debug.Print IsDate(Format("0955","00\:00"))
In article ,
"Patrick C. Simonds" wrote:
I am looking for something that will catch if the user does not enter a
valid time. For example if they were to enter 0995 instead of 0955.
|