Private Sub Tverif_Change(Index As Integer) If Len(Tverif(Index)) = 14 And Index < (Tverif.Count - 1) Then Tverif(Index + 1).SetFocus End Sub
Private Sub TVerif_LostFocus(Index As Integer) If TVerif(Index).Text = TRef.Text Then Lresu(Index).Caption = "OK" Else Lresu(Index).Caption = "ERREUR" End If End Sub
For i = 0 To Tserial.Count - 1 If i <> Index Then If Tserial(i).Text = Tserial(Index).Text Then Call MsgBox("REFERENCE DEJA ENTREE") Exit For End If End If Next
If Len(Tserial(Index)) = 10 Then Tverif(Index + 1).SetFocus End If
Private Sub T_netic_Change(Index As Integer) If Len(Tserial(Index)) = 10 And Index < (Tserial.Count - 1) Then For i = 0 To Tserial.Count - 1 If i <> Index Then If Tserial(Index).Text = Tserial(i).Text Then MsgBox ("N° de serie déja saisie."), 16, ("Erreur") Tserial(Index).Text = "" Else Tverif(Index + 1).SetFocus End If End If Next End If end sub
If Tserial(Index).TextTserial(i).Text ceci
AND len(Tserial(index))= 10
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub Tserial_Change(Index As Integer) For i = 0 To Tserial.Count - 1 If i <> Index ThenIf Tserial(Index).Text Tserial(i).Text And Len(Tserial(Index)) 10 Then MsgBox ("N° Etiquette déja saisie."), 16, ("Erreur") T_serial(Index).Text = "" End If Else If Len(Tserial(Index)) = 10 Then Tverif(Index + 1).SetFocus End If End If Exit For Next