Private Function GetIndex(ByVal strS As String) As Long Dim lLen As Long Dim I As Long Dim strT As String
lLen = Len(strS) For I = 1 To lLen strT = Mid(strS, I, 1) If Asc(strT) >= 48 And Asc(strT) <= 57 Then GetIndex = I Exit Function End If Next I GetIndex = -1 End Function
Dim lLen As Long
Dim I As Long
Dim strT As String
lLen = Len(strS)
For I = 1 To lLen
strT = Mid(strS, I, 1)
If Asc(strT) >= 48 And Asc(strT) <= 57 Then
GetIndex = I
Exit Function
End If
Next I
GetIndex = -1
End Function