InStr Function
Syntax:
InStr([Index, ]S1$,
S2$)
Group:
String
Description:
Return the index where S2$ first matches S1$. If no match is found return 0.
Note: A similar function, InStrB, returns the byte index instead.
Parameter
Description
Index Start
searching for S2$ at this index in S1$.
If this is omitted then start searching from the beginning of S1$.
S1$ Search
for S2$ in this string value. If this value
is Null then Null
is returned.
S2$ Search
S1$ for this string value. If this value is
Null then Null is
returned.
See
Also: InStrRev( ), Left$(
), Len( ), Mid$(
), Replace$( ), Right$(
).
Example:
Sub Main
Debug.Print InStr("Hello","l")
' 3
End Sub
