View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.