An optional integer argument, representing the position that you want to start searching from.

In the example above, the search begins at position 5 of the string "Test string" and so the function finds the second occurrence of "st" at position 6.

In the above example, the InStr function returns the position of the first lower case "t", which is position number 4.

The Complete Guide to Using Arrays in Excel VBA - Excel Macro Mastery

Note that, as the [Compare] argument is omitted, it is set to the default value vbBinaryCompare binary comparisonwhich is case sensitive.

In the above example, the sub-string "ZZ" is not found and so the InStr function returns the value 0.

Further information and examples of the VBA InStr function are provided on the Microsoft Developer Excel vba function argument default value. To control third party cookies, you can adjust your browser settings. By using our site you accept the terms of citigroup stock trading in real time Privacy Policy.

InStr [Start]String1String2[Compare].

Find the text "st" within the string "Test string", starting from position 1. Find the text "st" within the string "Test string", starting from position 5.

String Comparison Function in VBA | Excel & VBA – Databison

Find the text "t" within the string "Test string", starting from position 1. Find the text "ZZ" within the string "Test string", starting from position 1. Return to the List of VBA Functions Return to the ExcelFunctions.

If omitted, the [Start] argument takes on the default value of 1. An optional argument, specifying the type of comparison to make. This can be any of the following values: