Need help utilizing the "Like" function
Using Excel 2003, here is example code that doesn't work. What am I doing
wrong?
My isNumeric test returns "True", but there an "A" in my string.
Am I not checking for all the character to be 0 - 9?
Sub Test1()
Debug.Print isNumeric("A00101")
End Sub
Function isNumeric(ByVal sInput As String) As Boolean
If sInput Like "*[0-9]" Then
isNumeric = True
Else
isNumeric = False
End If
End Function
Thanks,
- Pat
|