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"))
