Validate Email Format. Check format of email address

To check if email format is correct

1. Copy the code below.
2. Open any workbook.
3. Press Alt + F11 to open the Visual Basic Editor (VBE).
4. Press Ctrl + R to show the Project Explorer.
5. Right-click desired file on left (in bold).
6. From the Menu, choose Insert-Module.
7. Paste the code into the right-hand code window.
8. Close the VBE, save the file  as VBA Enabled WorkBook (xlsm) for Excel 2010 and newer