Function String Searches Class ★ Top 20 Most Useful

InStrCharacters

"In String Characters" Return the first position within string vLine of any of the characters within vFindChars.

Signature (Visual Basic / VBA)

Public Function InStrCharacters( _
      ByVal vStartPos As Variant _
    , ByVal vLine As Variant _
    , ByVal vFindChars As Variant _
    , Optional ByVal vCompare As Variant _
    ) As Variant

Code Example

    InStrCharacters(1, "321CBACBA", "ABC") = 4
    InStrCharacters(4, "321CBACBA", "123") = 0

Parameters

Parameter Description
vStartPos The position of the character in string vLine where the search is to begin. vStartPos defaults to 1 (one) if it is Null or cannot be fixed up to a number.
vLine The string which is to be searched from left-to-right for characters that appear in string vFindChars. Function returns Null if vLine is Null or cannot be fixed up to a String.
vFindChars String containing characters that are to be searched for within string vLine. Function returns Null if vFindChars is Null or cannot be fixed up to a String. Function returns 0 (zero) if vFindChars is an empty string.
vCompare Specifies the type of comparison used to find matching characters present in both strings. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number. Function returns 0 (zero) if none of the characters in string vFindChars appear within string vLine.