Automate Excel » VBA: Find Text in a String (instr)

You can use the instr function in VBA to test if a string contains certain text. The result is the number of times the specified text appears in the string. The following code snippet tests the string “Look in this string” for the word “Look”. The result

www.automateexcel.com