Bonsoir Mferrand
voila un exemple
Option Base 1
Sub mdp()
Dim tablo1(), tablo2() As Variant
Dim mdp1, mdp2 As String
Dim n As Integer
tablo1 = Array("a", "b", "c", "d")
tablo2 = Array("alpha", "beta", "ceti", "deka")
MsgBox tablo1(2) & " " & tablo2(2)
mdp1 = InputBox("Saisie identifiant : ", "Ident.")
mdp2 = InputBox("Saisie mot de passe : ", "mdp.")
If (mdp1 Like tablo1(1) And mdp2 Like tablo2(1)) Or _
(mdp1 Like tablo1(2) And mdp2 Like tablo2(2)) Or _
(mdp1 Like tablo1(3) And mdp2 Like tablo2(3)) Or _
(mdp1 Like tablo1(4) And mdp2 Like tablo2(4)) Then
MsgBox "saisie correct"
Else
MsgBox "mdp incorrect"
End If
End Sub
je souhaitais reduire l'ecriture des "ou " qu'on peut voir de facon assez repetitive dans mon code