Function RegExpTest(patrn, strng)
Dim regEx, Matches
Set regEx = New RegExp
regEx.Pattern = patrn
regEx.IgnoreCase = True ‘为真则忽略大小写,否则严格匹配大小写
regEx.Global = True
Set Matches = regEx.Execute(strng)
RegExpTest = Matches.count
End Function
MsgBox(RegExpTest("is.", "IS1 is2 IS3 is4"))