Hi again,
How it is possible to control the entry for the E-mail address?
I mean if there is no '@' or '.' and more that I dont know, maybe you know better and faced to such problem
Validate Email Address Entry
-
cs2007 -
July 3, 2007 at 8:06 AM -
Closed
-
-
-
-
Re: Control Entering E-mail Address
Data Validation with a Custom>Formula like;
=AND(FIND(".",A1),FIND("@",A1))
-
Re: Control Entering E-mail Address
Quote from jindonFYI, I have a text box on a userform, which the user enter his/Her mail address, could you please be a little more detailed? where to put the function and how call? where call from?
-
Re: Control Entering E-mail Address
Why didn't you state that 1st up?
-
-
Re: Control Entering E-mail Address
I am sorry for that...
-
Re: Control Entering E-mail Address
Code
Display MoreDim bNotValid As Boolean Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) ValidateEmail Cancel = bNotValid bNotValid = False End Sub Private Sub ValidateEmail() If ActiveControl <> vbNullString Then If InStr(1, ActiveControl, ".") = 0 Or InStr(1, ActiveControl, "@") = 0 Then MsgBox "Email address not valid" bNotValid = True End If End If End Sub
-
-
Re: Control Entering E-mail Address
Thanks very much from both of you...They both working well
-
Re: Control Entering E-mail Address
Quote from LOGThanks very much from both of you...They both working well
Are you sure?
You don't want to accept a string such as
abc...@@@.com...
Do you?
-
-
Re: Control Entering E-mail Address
I would have them type the email address twice and compare the 2.
-
-
Re: Validate Email Address Entry
I don't understand how the multiple entry will check a valid email address.
-
Re: Validate Email Address Entry
It greatly reduces the chances of typos. As xlite states, it's the standard used when typing email addresses.
-
Re: Validate Email Address Entry
But it still doesn't check if it is valid or not.
It just check if the entries are the same.
-
-
Re: Validate Email Address Entry
Yes, that's right. The chances of a typo twice is a LOT less than once.
-
Re: Validate Email Address Entry
I don't think the OP is asking such thing.
-
Re: Control Entering E-mail Address
Quote from LOGThanks very much from both of you...They both working well
Jindon, if you want to write a different Function just do it. You don't need me or anyone else to give you the go-ahead...........do you?
-
-
Re: Validate Email Address Entry
WHOA!!!! Jindon, you are a valued member, and I'm sure Dave knows that. Take five, guys, and have a little relax, eh?
-
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!