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