1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| Dim monTab() As String
Dim strSearch As String
Dim X As Integer
Dim Cnt As Integer
Dim mesvariables() As String
ReDim mesvariables(0)
ReDim mesvariables(1)
ReDim mesvariables(2)
mesvariables(0) = strMessage2
mesvariables(1) = strMessage3
mesvariables(2) = strMessage4
monTab = Split(strMessage1, "@")
strSearch = monTab(1)
Cnt = 0
For X = 0 To UBound(monTab)
If InStr(1, strSearch, mesvariables(X)) > 0 Then
Cnt = Cnt + 1
End If
Next X
If Cnt = UBound(monTab) Then
MsgBox "le mot : " & strSearch & " est présent dans toutes les variables"
End If |
Partager