Re,
Si on veut trouver une occurrence exacte, il ne faut pas utiliser INSTR()
Sub FindWord(vSearch As String)
Dim Poste() As Variant
Dim Inc As Integer, Ind As Integer
Poste = Array("A1", "A2", "A3G", "AAD", "AAG", "AAD", "PRA", "AD", "A3D", "A3GG", "A3", "EXC", "AA4G", "AAM4", "AUA1", "ABA1A", "AAB2")
For Ind = 0 To UBound(Poste) - 1
If UCase(vSearch) = Poste(Ind) Then
'If InStr(1, vSearch, Poste(Ind), vbTextCompare) > 0 Then
MsgBox "Trouvé !"
Exit For
End If
Next Ind
End Sub
Mais du coup, nous sommes hors sujet par rapport à l'exemple du début
@+