RegEx in VBA

[ddonnahoe]

Does any one know if it's possible to use Regular expression in VBA?

[Alex]

Yes, you can. Here is an example:

Public Sub TestRegEx()
    Dim regEx As Object
    Dim matches As Object
    Dim match As Variant
    
    Set regEx = CreateObject("VBScript.RegExp")
    regEx.Global = True
    regEx.Pattern = "\d{3}-\d{2}-\d{2}" 'Match a phone number

    Set matches = regEx.Execute("Phone numbers: 555-12-34, 555-56-78.")
    
    For Each match In matches
        Debug.Print "Match Found: " & match
    Next
End Sub

You can see more about VBScript.RegExp object here: http://msdn.microsoft.com/en-us/libr...yh(VS.85).aspx

I hope this helps.

[ddonnahoe]

Thanks Alex. This is awesome.