The following code snippet will show you how to use regular expressions in VBA.
This code references the folowing API, which is a VBScript API.
"Microsoft VBScript Regular Expression Reference 5.5"
In order to reference this API in Excel VBA goto Options -> References (In German "Extras" -> "Verweise") and tick the API above.
Here is a link to a more detailed article on regular expressions in VBScript and VBA.
And here a link on regular expressions in general. I found it very helpful, as I would not consider myself someone who fully understands regular expressions.
I just like to use them as they make my life much easier.
Since I do not wanrt to spend a lot of time on testing my regular expressions in my tools, here a link on a regex tester.