mot = "manoeuvre" messyllabes = "aeiouéèàïù" Dim mot_eclate() As Byte mot_eclate = StrConv(mot, vbFromUnicode) deja 0: nbfictif_voyelles 0 For i = 0 To UBound(mot_eclate) If InStr(UCase(messyllabes), UCase(Chr(mot_eclate(i)))) > 0 Then If deja 0 Or i - deja > 1 Then nbfictif_voyelles nbfictif_voyelles + 1 deja = i End If Next MsgBox nbfictif_voyelles