is it possible to check the format of a time value (like hh:mm) without
having to use regular expressions. the numberformat function doest seem to be
applicable to time

Try some code like the following:

Dim S1 As String
Dim T As Date
S1 = "12:34"
On Error Resume Next
T = TimeValue(S1)
If Err.Number = 0 Then
Debug.Print "valid time"
Else
Debug.Print "Not a valid time"
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"phil" wrote in message
...
is it possible to check the format of a time value (like hh:mm)
without
having to use regular expressions. the numberformat function
doest seem to be
applicable to time

I am not 100% sure what you mean? If I run this code with Cell A1 foramtted
"hh:mm", it seems to work...
--
HTH...

Jim Thomlinson


"phil" wrote:

is it possible to check the format of a time value (like hh:mm) without
having to use regular expressions. the numberformat function doest seem to be
applicable to time

I meant this code... The intricacies of Cut and Paste is lost on me today...

MsgBox Range("A1").NumberFormat
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

I am not 100% sure what you mean? If I run this code with Cell A1 foramtted
"hh:mm", it seems to work...
--
HTH...

Jim Thomlinson


"phil" wrote:

is it possible to check the format of a time value (like hh:mm) without
having to use regular expressions. the numberformat function doest seem to be
applicable to time