sorry i'm a little new to excel

i found this http://www.excelitems.com/2010/11/va...addresses.html
and it's perfect for what i want but i couldn't get it to work somehow. I'm using MS Excel 2010.

nothing seems to happen when i type invalid emails in there