Executes a regular expression search against a specified string and returns a Boolean value that indicates if a pattern match was found.
The Execute method syntax has these parts:
Required. Always the name of a RegExp object.
Required. The text string upon which the regular expression is executed.
The actual pattern for the regular expression search is set using the Pattern property of the RegExp object. The RegExp.Global property has no effect on the Test method.
The Test method returns True if a pattern match is found; False if no match is found.
The following code illustrates the use of the Test method:
Function RegExpTest(patrn, strng)
Dim regEx, retVal ' Create variable.
Set regEx = New RegExp ' Create regular expression.
regEx.Pattern = patrn ' Set pattern.
regEx.IgnoreCase = False ' Set case sensitivity.
retVal = regEx.Test(strng) ' Execute the search test.
If retVal Then
RegExpTest = "One or more matches were found."
RegExpTest = "No match was found."
MsgBox(RegExpTest("is.", "IS1 is2 IS3 is4"))