Sub CYCLECONTROLE2()
If Sheets('CONTROLE2').Range('W1').Value = ('DETERS_1/1') Then
Sheets('CONTROLE2').Select
Range('A1:AO1').Select
Selection.Cut
Sheets('CONTROLE2').Select
L = Sheets('CONTROLE2').Range('A150').End(xlUp).ROW + 1
Sheets('CONTROLE2').Range('A' & L).Select
ActiveSheet.Paste
Sheets('CONTROLE2').Select
Range('A1').Select
Sheets('CONTROLE2').Rows(ListIndex + 1).Delete
Call CYCLECONTROLE2
Else: Sheets('CONTROLE2').Select
If Sheets('CONTROLE2').Range('A1').Value = Sheets('CONTROLE2').Range('A2').Value Then 'NOM
Else: MsgBox 'NOM '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('B1').Value = Sheets('CONTROLE2').Range('B2').Value Then 'PRENOM
Else: MsgBox 'ERREUR DATE DE NAISSANCE '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('D1').Value = Sheets('CONTROLE2').Range('D2').Value Then 'DATE DE NAISSANCE
Else: MsgBox 'ERREUR DATE DE NAISSANCE '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('N1').Value = Sheets('CONTROLE2').Range('N2').Value Then 'GROUPE
Else: MsgBox 'ERREUR GROUPE '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('O1').Value = Sheets('CONTROLE2').Range('O2').Value Then 'D
Else: MsgBox 'ERREUR D '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('R1').Value = Sheets('CONTROLE2').Range('R2').Value Then 'PHENOTYPE
Else: MsgBox 'ERREUR PHENOTYPE '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('P1').Value = Sheets('CONTROLE2').Range('P2').Value Then 'KELL
Else: MsgBox 'ERREUR KELL '
Call ERREUR2
Exit Sub
End If
Sheets('CONTROLE2').Select
Range('A1:AO2').Select
Selection.Cut
Sheets('CONTROLE2').Select
L = Sheets('CONTROLE2').Range('A150').End(xlUp).ROW + 1
Sheets('CONTROLE2').Range('A' & L).Select
ActiveSheet.Paste
Sheets('CONTROLE2').Select
Range('A1').Select
Sheets('CONTROLE2').Rows(ListIndex + 1).Delete
Sheets('CONTROLE2').Rows(ListIndex + 1).Delete
If Sheets('CONTROLE2').Range('AO1').Value = ('S') Then
Dim TEMP As String
TEMP = MsgBox('CONTRÔLE DETERMINATIONS OK', vbOKOnly + vbDefaultButton1 + vbInformation, 'CONTROLE OK')
TEMP = MsgBox('VOULEZ VOUS LANCER L'EDITION', vbYesNo + vbDefaultButton1 + vbExclamation, 'EDITIONS DES CARTES')
If TEMP = vbYes Then
MultiPage1.Value = 0
Call EDITION
Else: MultiPage1.Value = 0
Exit Sub
End If
Exit Sub
Else: Call CYCLECONTROLE2
End If
End If
End Sub
If Sheets('CONTROLE2').Range('W1').Value = ('DETERS_1/1') Then
Sheets('CONTROLE2').Select
Range('A1:AO1').Select
Selection.Cut
Sheets('CONTROLE2').Select
L = Sheets('CONTROLE2').Range('A150').End(xlUp).ROW + 1
Sheets('CONTROLE2').Range('A' & L).Select
ActiveSheet.Paste
Sheets('CONTROLE2').Select
Range('A1').Select
Sheets('CONTROLE2').Rows(ListIndex + 1).Delete
Call CYCLECONTROLE2
Else: Sheets('CONTROLE2').Select
If Sheets('CONTROLE2').Range('A1').Value = Sheets('CONTROLE2').Range('A2').Value Then 'NOM
Else: MsgBox 'NOM '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('B1').Value = Sheets('CONTROLE2').Range('B2').Value Then 'PRENOM
Else: MsgBox 'ERREUR DATE DE NAISSANCE '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('D1').Value = Sheets('CONTROLE2').Range('D2').Value Then 'DATE DE NAISSANCE
Else: MsgBox 'ERREUR DATE DE NAISSANCE '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('N1').Value = Sheets('CONTROLE2').Range('N2').Value Then 'GROUPE
Else: MsgBox 'ERREUR GROUPE '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('O1').Value = Sheets('CONTROLE2').Range('O2').Value Then 'D
Else: MsgBox 'ERREUR D '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('R1').Value = Sheets('CONTROLE2').Range('R2').Value Then 'PHENOTYPE
Else: MsgBox 'ERREUR PHENOTYPE '
Call ERREUR2
Exit Sub
End If
If Sheets('CONTROLE2').Range('P1').Value = Sheets('CONTROLE2').Range('P2').Value Then 'KELL
Else: MsgBox 'ERREUR KELL '
Call ERREUR2
Exit Sub
End If
Sheets('CONTROLE2').Select
Range('A1:AO2').Select
Selection.Cut
Sheets('CONTROLE2').Select
L = Sheets('CONTROLE2').Range('A150').End(xlUp).ROW + 1
Sheets('CONTROLE2').Range('A' & L).Select
ActiveSheet.Paste
Sheets('CONTROLE2').Select
Range('A1').Select
Sheets('CONTROLE2').Rows(ListIndex + 1).Delete
Sheets('CONTROLE2').Rows(ListIndex + 1).Delete
If Sheets('CONTROLE2').Range('AO1').Value = ('S') Then
Dim TEMP As String
TEMP = MsgBox('CONTRÔLE DETERMINATIONS OK', vbOKOnly + vbDefaultButton1 + vbInformation, 'CONTROLE OK')
TEMP = MsgBox('VOULEZ VOUS LANCER L'EDITION', vbYesNo + vbDefaultButton1 + vbExclamation, 'EDITIONS DES CARTES')
If TEMP = vbYes Then
MultiPage1.Value = 0
Call EDITION
Else: MultiPage1.Value = 0
Exit Sub
End If
Exit Sub
Else: Call CYCLECONTROLE2
End If
End If
End Sub