I am currently extracting some information out of a long string of text and one of the variables I am extracting is plain numbers approx 6 charaacters in length.
Unfortunatly some people have put in strings such as 00:20 which causes a Type Mismatch as I only want to output numbers.
Therefore I am trying the like operator to capture these but I have a problem:
currently using :
---------------------------------------------------------------------------
varUserErr = strTime Like "[0-9]"
If varUserErr = False Then
msgbox "Another idiot has put the wrong info in!"
End If
---------------------------------------------------------------------------
The problem is that if they put in 20 or anything else with more than 1 digit it returns False,
Therefore how can I check for 6 characters of just numbers?
