Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub Command1_Click() 'Mise en mémoire des infos du texte p1 = 1 'Point de départ p2 = Len(Text1.Text) 'Longueur du Texte 'Recherche du début des lettres / fin des chiffres Do Until p1 > p2 sLetter = Mid(Text1.Text, p1, 1) If sLetter <> "0" And sLetter <> "1" And sLetter <> "2" And sLetter <> "3" And sLetter <> "4" And sLetter <> "5" And sLetter <> "6" And sLetter <> "7" And sLetter <> "8" And sLetter <> "9" Then pEndInt = p1 Exit Do End If p1 = p1 + 1 Loop 'Recherche fin des lettres / début des chiffres Do Until p1 > p2 sLetter = Mid(Text1.Text, p1, 1) If sLetter "0" Or sLetter "1" Or sLetter = "2" Or sLetter = "3" Or sLetter = "4" Or sLetter = "5" Or sLetter = "6" Or sLetter = "7" Or sLetter = "8" Or sLetter = "9" Then pStartInt = p1 Exit Do End If p1 = p1 + 1 Loop 'Mise en format du texte FstPart = Format(Mid(Text1.Text, 1, pEndInt - 1), "00000") ScdPart = Format(Mid(Text1.Text, pStartInt), "000") MsgBox "la plaque est : " & FstPart & "-" & Mid(Text1.Text, pEndInt, pStartInt - pEndInt) & "-" & ScdPart End Sub
Dim Accept(nombre de possibilités) As String Accept(1) = "#?##" Accept(2) = "##?##" Accept(3) = "###?##" Accept(4) = "####?##" Accept(5) = "#??##" Accept(6) = "##??##" Accept(7) = "###??##" Accept(8) = "####??##" Accept(9) = "#???##" Accept(10) = "##???##" Accept(11) = "###???##" Accept(12) = "####???##" Accept(13) = "#?2A" 'etc ... (finir avec la Corse)
Dim Acceptable As Boolean Acceptable = False For i = 1 To nombre de possibilités If Text1.Text Like Accept(i) Then Acceptable = True Exit For End If Next i If Acceptable Then 'Immatriculation correcte : enregistrement Else 'Refusé : MsgBox et retour à la saisie End If