The string to be searched.
The substring to be found within
The starting position of the search. If no value is specified,
start defaults to 1.
A constant indicating how
stringmatch should be compared.
Determines the starting position of a substring within a string by searching from the end of the string to its beginning
While InStr searches a string from left to right, InStrRev searches a string from right to left.
compare argument can be one of
CompareMethod.Binary (for a case- sensitive
CompareMethod.Text (for a
case-insensitive search). If
omitted, the type of comparison is binary. Note that
Compare is not used,
unlike with the InStr function.
start designates the starting point of the
search as counted from the start of
stringcheck. To start the search at the
stringcheck, either omit the
start argument or set it to
stringmatch is not found,
InStrRev returns 0.
stringmatch is found within
stringcheck, the value returned by
InStrRev is the position of
stringcheck from the start of the string.
This example uses both InStr and
InStrRev to highlight the different results
produced by each. Using a