'Prepare a regular expression object Dim myRegExp As RegExp Dim myMatches As MatchCollection Dim myMatch As Match Set myRegExp = New RegExp myRegExp.IgnoreCase = True myRegExp.Global = True myRegExp.Pattern = "regex" Set myMatches = myRegExp.Execute(subjectString) For Each myMatch in myMatches MsgBox(myMatch.Value) Next