email address on userform

[Kevin0427]

I have created a userform that asks for an email address. Does anybody have some code that would verify the email address has the correct format (I don't need to verify the address actually exists). Thanks so much !! The web is just getting me lost and confused.

 

[Joe4]

If you do a Google search, you can find various VBA code that people have come up with to validate email addresses.
Here is one: https://www.geeksengine.com/article/validate-email-vba.html, but you can find a lot more out there.

 

[DanteAmor]

Here are a couple of alternatives.

https://www.mrexcel.com/forum/excel-questions/986125-email-address-validation.html

https://www.mrexcel.com/forum/excel-questions/268673-vba-textbox-email-validation.html

 

[Kevin0427]

Thanks Dante! The first link worked well. The second thread I had seen but did not cover all the bases well enough.

 

[DanteAmor]

Im glad to help you, thanks for the feedback.