Option Explicit
Public Function validate_email(ByVal email As String) As Boolean
Dim i As Integer
Dim j As Integer
Dim chracter As String
Dim pos As Integer
Dim bool As Boolean
Dim pos1 As Integer
Dim pos2 As Integer
On Local Error GoTo err_sub
email = Trim$(email)
If email = vbNullString Then
Exit Function
End If
email = LCase$(email)
j = Len(email)
For i = 1 To j
chracter = Mid(email, i, 1)
If (Not (chracter Like "[a-z]")) And (Not (chracter Like "[0-9]")) Then
If InStr(1, "_-" & "." & "@", chracter) > 0 Then
If bool = True Then
Exit Function
Else
bool = True
If i = 1 Or i = j Then
Exit Function
End If
If chracter = "@" Then
If pos1 = 0 Then
pos1 = i
Else
Exit Function
End If
End If
If chracter = "." Then
pos2 = i
End If
End If
Else
Exit Function
End If
Else
bool = False
End If
Next i
If pos1 = 0 Or pos2 = 0 Then
Exit Function
End If
validate_email = True
Exit Function
err_sub:
On Local Error Resume Next
validate_email = False
End Function
Private Sub Command1_Click()
MsgBox "email check : " & Text1 & vbNewLine & _
Format(validate_email(Text1), "YES/NO") & " <<<< valid ", vbInformation
End Sub
Private Sub Form_Load()
Command1.Caption = "email validation"
Text1 = "enter email"
Views: 168