Looking for vba Answers? Try Ask4KnowledgeBase
Looking for vba Keywords? Try Ask4Keywords

VBASearching within strings for the presence of substrings


When you need to check for the presence or position of a substring within a string, VBA offers the InStr and InStrRev functions that return the character position of the substring in the string, if it is present.