VBA – RegEx in Excel

There is a well-known joke in the IT world – if you have a problem and you try RegEx to solve it, now you have two problems.

Still, RegEx in VBA (and thus in Excel) exists as an additional library. If you are not a fan of asking people to add libraries to your project, in VBA you may use the late binding. This is a simple example of a custom excel formula for verification of an email through RegEx:

And this is how it looks in Excel:

Tagged with: , , ,