1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Public Function eMailValide(sAdresse As String) As Boolean
Dim regEx As RegExp, occurrences As MatchCollection
On Error GoTo GestionErreur
'Vérifier si Microsoft VBScript Regular Expressions est présente
Application.References.AddFromGuid "{3F4DACA7-160D-11D2-A8E9-00104B365C9F}", 5, 5
'
Set regEx = New RegExp
regEx.Pattern = "^([\w_.-]+)@([\w]{2,})\.[a-z]{2,3}$"
regEx.Global = False 'Renvoyer seulement la première occurrence
Set occurrences = regEx.Execute(sAdresse)
eMailValide = (occurrences.Count = 1)
Exit Function
GestionErreur:
Select Case Err.Number
Case 32813 ' la référence existe déjà
Resume Next
Case Else
MsgBox "Erreur dans eMailValide" & vbLf & Err.Number & vbLf & Err.Description
End Select
End Function |
Partager