Check if a User's Email already exists in a range

Hey guys, could someone take a look at my code and help me with my For Loop? I am new to this, but I want it to check if the user's email is already "registered". If it is, I want it to say Already Registered, and close the userform. If not, I want it to set the values of the userform to the worksheet. Thanks!!!

Please Login or Register  to view this content.