Private Sub UserForm_Initialize()
Dim i As Byte
Dim tabTCFM(2) As String
Dim tabNICER(2) As String
Dim tabNEUTRE(6) As String
Dim tabTRA(3) As String
Dim TabCalibre(3) As String
tabTCFM(0) = "Présent"
tabTCFM(1) = "Absent"
tabNICER(0) = "Départ Aérien"
tabNICER(1) = "Départ Souterrain"
tabTRA(0) = "225KV/20KV 1E"
tabTRA(1) = "225KV/20KV 2E"
tabTRA(2) = "63KV/20KV"
tabNEUTRE(0) = "NI/-"
tabNEUTRE(1) = "NC/-"
tabNEUTRE(2) = "NI/NC"
tabNEUTRE(3) = "NI/NI"
tabNEUTRE(4) = "NC/NI"
tabNEUTRE(5) = "NC/NC"
DateDefaut = DateSerial(Year(Date), Month(Date), 1)
DateEssais.Value = DateDefaut
FinEssais.Value = DateDefaut
Expedition.Value = DateDefaut
DateB2B5.Value = DateDefaut
DateSUP.Value = DateDefaut
DateD82.Value = DateDefaut
DateTCFM.Value = DateDefaut
TabCalibre(0) = ""
TabCalibre(1) = "48 Vcc"
TabCalibre(2) = "125 Vcc"
NompPoste = ""
Calibre48125 = ""
ValTCFM = ""
For i = 0 To 6
tabNomRame(i) = ""
Next i
For i = 0 To 2
Calibre.AddItem "" & TabCalibre(i)
Next i
For i = 1 To 3
NbreTransfo.AddItem "" & i
Next i
For i = 1 To 3
NbreCTL.AddItem "" & i
Next i
For i = 0 To 2
TypeLotTRA1.AddItem "" & tabTRA(i)
TypeLotTRA2.AddItem "" & tabTRA(i)
TypeLotTRA3.AddItem "" & tabTRA(i)
Next i
For i = 0 To 5
TypeNeutreTRA1.AddItem "" & tabNEUTRE(i)
TypeNeutreTRA2.AddItem "" & tabNEUTRE(i)
TypeNeutreTRA3.AddItem "" & tabNEUTRE(i)
Next i
For i = 0 To 1
TCFM.AddItem "" & tabTCFM(i)
Next i
For i = 0 To 1
TypeNicer1.AddItem tabNICER(i)
TypeNicer2.AddItem tabNICER(i)
TypeNicer3.AddItem tabNICER(i)
TypeNicer4.AddItem tabNICER(i)
TypeNicer5.AddItem tabNICER(i)
TypeNicer6.AddItem tabNICER(i)
TypeNicer7.AddItem tabNICER(i)
TypeNicer8.AddItem tabNICER(i)
TypeNicer1_2.AddItem tabNICER(i)
TypeNicer2_2.AddItem tabNICER(i)
TypeNicer3_2.AddItem tabNICER(i)
TypeNicer4_2.AddItem tabNICER(i)
TypeNicer5_2.AddItem tabNICER(i)
TypeNicer6_2.AddItem tabNICER(i)
TypeNicer7_2.AddItem tabNICER(i)
TypeNicer8_2.AddItem tabNICER(i)
TypeNicer1_3.AddItem tabNICER(i)
TypeNicer2_3.AddItem tabNICER(i)
TypeNicer3_3.AddItem tabNICER(i)
TypeNicer4_3.AddItem tabNICER(i)
TypeNicer5_3.AddItem tabNICER(i)
TypeNicer6_3.AddItem tabNICER(i)
TypeNicer7_3.AddItem tabNICER(i)
TypeNicer8_3.AddItem tabNICER(i)
TypeNicer1_4.AddItem tabNICER(i)
TypeNicer2_4.AddItem tabNICER(i)
TypeNicer3_4.AddItem tabNICER(i)
TypeNicer4_4.AddItem tabNICER(i)
TypeNicer5_4.AddItem tabNICER(i)
TypeNicer6_4.AddItem tabNICER(i)
TypeNicer7_4.AddItem tabNICER(i)
TypeNicer8_4.AddItem tabNICER(i)
TypeNicer1_5.AddItem tabNICER(i)
TypeNicer2_5.AddItem tabNICER(i)
TypeNicer3_5.AddItem tabNICER(i)
TypeNicer4_5.AddItem tabNICER(i)
TypeNicer5_5.AddItem tabNICER(i)
TypeNicer6_5.AddItem tabNICER(i)
TypeNicer7_5.AddItem tabNICER(i)
TypeNicer8_5.AddItem tabNICER(i)
TypeNicer1_6.AddItem tabNICER(i)
TypeNicer2_6.AddItem tabNICER(i)
TypeNicer3_6.AddItem tabNICER(i)
TypeNicer4_6.AddItem tabNICER(i)
TypeNicer5_6.AddItem tabNICER(i)
TypeNicer6_6.AddItem tabNICER(i)
TypeNicer7_6.AddItem tabNICER(i)
TypeNicer8_6.AddItem tabNICER(i)
Next i
For i = 0 To 11
MultiPage1.Pages(i).Enabled = True
MultiPage1.Value = i
Select Case i
Case 6: DateMESCTL1.Value = DateDefaut
DateCgtCTL1.Value = DateDefaut
DateEssaiCTL1.Value = DateDefaut
DateFinEssaisCTL1.Value = DateDefaut
Case 7: DateMESCTL2.Value = DateDefaut
DateCgtCTL2.Value = DateDefaut
DateEssaiCTL2.Value = DateDefaut
DateFinEssaisCTL2.Value = DateDefaut
Case 8: DateMESCTL3.Value = DateDefaut
DateCgtCTL3.Value = DateDefaut
DateEssaiCTL3.Value = DateDefaut
DateFinEssaisCTL3.Value = DateDefaut
Case 9: DateESTRA1.Value = DateDefaut
DateChtTRA1.Value = DateDefaut
DateEssaisTRA1.Value = DateDefaut
DateFinEssaisTRA1.Value = DateDefaut
Case 10: DateESTRA2.Value = DateDefaut
DateChtTRA2.Value = DateDefaut
DateEssaisTRA2.Value = DateDefaut
DateFinEssaisTRA2.Value = DateDefaut
Case 11: DateESTRA3.Value = DateDefaut
DateChtTRA3.Value = DateDefaut
DateEssaisTRA3.Value = DateDefaut
DateFinEssaisTRA3.Value = DateDefaut
End Select
MultiPage1.Pages(i).Enabled = False
Next i
For i = 12 To 13
MultiPage1.Pages(i).Enabled = True
MultiPage1.Value = i
Select Case i
Case 12: DateESAUTO.Value = DateDefaut
DateChtAUTO.Value = DateDefaut
DateEssaisAUTO.Value = DateDefaut
DateFinEssaisAUTO.Value = DateDefaut
Case 13: DateESSUP.Value = DateDefaut
DateChtSUP.Value = DateDefaut
DateEssaisSUP.Value = DateDefaut
DateFinEssaisSUP.Value = DateDefaut
End Select
Next i
MultiPage1.Pages(14).Enabled = True
MultiPage1.Value = 14
DateESTCFM.Value = DateDefaut
DateChtTCFM.Value = DateDefaut
DateEssaisTCFM.Value = DateDefaut
DateFinEssaisTCFM.Value = DateDefaut
MultiPage1.Pages(14).Enabled = False
Worksheets("TRA1").Unprotect
Worksheets("TRA2").Unprotect
Worksheets("TRA3").Unprotect
Worksheets("TRADouble1").Unprotect
Worksheets("TRADouble2").Unprotect
Worksheets("TRADouble3").Unprotect
Worksheets("Arrivée").Unprotect
Worksheets("Départ Aérien").Unprotect
Worksheets("Départ Souterrain").Unprotect
Worksheets("Condensateur").Unprotect
Worksheets("Couplage (CP)").Unprotect
Worksheets("Shunt").Unprotect
Worksheets("Essais Communs 1").Unprotect
Worksheets("Essais Communs 2").Unprotect
Worksheets("Essais Communs 3").Unprotect
Call Affiche_Donnees
End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub UserForm_Initialize()
...
...
Call Affiche_Donnees
End Sub
Sub Affiche_Donnees()
If PREPAREPV.Enabled = False Then 'désactiver
Worksheets("Données").Visible = True
Call Lecture_donnees
Call Affiche_Donnees_saisies
Worksheets("Données").Visible = xlSheetHidden
End If
If PREPAREPV.Enabled = True Then 'activer
Worksheets("Données").Visible = True
End If
End Sub
Call Lecture_donneesnous voilà maintenant renvoyés à 2 autres procédures dont nous ignorons le contenu !
Call Affiche_Donnees_saisies
'*********************************************************************************************************'
Sub Lecture_donnees()
Dim Feuille As String
Dim i As Integer
Dim j As Integer
Dim z As Integer
Feuille = "Données"
Sheets(Feuille).Select
Sheets(Feuille).Unprotect
'info poste
Nom_Poste = Cells(2, 2).Value
If Nom_Poste = "" Then
Exit Sub
End If
Num_OF = Cells(3, 2).Value
Num_AR = Cells(4, 2).Value
DateEssai = Cells(5, 2).Value
DateFinEssai = Cells(6, 2).Value
DateExpe = Cells(7, 2).Value
Calibre48125 = Cells(8, 2).Value
Date_B2B5 = Cells(9, 2).Value
Version_B2B5 = Cells(10, 2).Value
Date_SUP = Cells(11, 2).Value
Version_SUP = Cells(12, 2).Value
Date_D82 = Cells(13, 2).Value
Version_D82 = Cells(14, 2).Value
VCONFLOT_AUTO = Cells(15, 2).Value
VCONFLOT_TRA = Cells(16, 2).Value
VCONFLOT_RAME = Cells(17, 2).Value
NbreTRA = Cells(18, 2).Value
Nbre_CTL = Cells(19, 2).Value
ValTCFM = Cells(20, 2).Value
DateRecepTCFM = Cells(21, 2).Value
Version_TCFM = Cells(22, 2).Value
Version_CD = Cells(23, 2).Value
Version_CDL = Cells(24, 2).Value
Version_TMS = Cells(25, 2).Value
'composition des rames
j = 16
For i = 0 To (Nbre_CTL * 2) - 1
tabNomRame(i) = Cells(30 + (j * i), 1).Value
tabArrivee(i) = Cells(30 + (j * i), 2).Value
tabDA(i) = Cells(30 + (j * i), 3).Value
tabDS(i) = Cells(30 + (j * i), 4).Value
tabCD(i) = Cells(30 + (j * i), 5).Value
tabCP(i) = Cells(30 + (j * i), 6).Value
tabSH(i) = Cells(30 + (j * i), 7).Value
Next i
For i = 0 To (Nbre_CTL * 2) - 1
tabNomCellAR(i) = Cells(32 + (j * i), 2).Value
tabNumSerie_AR(i) = Cells(32 + (j * i), 3).Value
tabNomCellCD(i) = Cells(41 + (j * i), 2).Value
tabNumSerie_CD(i) = Cells(41 + (j * i), 3).Value
tabNomCellCP(i) = Cells(42 + (j * i), 2).Value
tabNumSerie_CP(i) = Cells(42 + (j * i), 3).Value
tabNomCellSH(i) = Cells(43 + (j * i), 2).Value
tabNumSerie_SH(i) = Cells(43 + (j * i), 3).Value
Next i
For i = 0 To (Nbre_CTL * 2) - 1
TabNicerARCDCPSH(i, 0) = Cells(32 + (j * i), 1).Value
Next i
For i = 0 To (Nbre_CTL * 2) - 1
TabNicerARCDCPSH(i, 1) = Cells(41 + (j * i), 1).Value
Next i
For i = 0 To (Nbre_CTL * 2) - 1
TabNicerARCDCPSH(i, 2) = Cells(42 + (j * i), 1).Value
Next i
For i = 0 To (Nbre_CTL * 2) - 1
TabNicerARCDCPSH(i, 3) = Cells(43 + (j * i), 1).Value
Next i
For x = 0 To (Nbre_CTL * 2) - 1
For i = 0 To 7
tabTypeNICER(x, i) = Cells(33 + (x * j) + i, 1).Value
tabNomCellDep(x, i) = Cells(33 + (x * j) + i, 2).Value
tabNumSerie_Dep(x, i) = Cells(33 + (x * j) + i, 3).Value
Next i
Next x
'CTL1, à CTL3
j = 4
For i = 0 To 2
Num_OFCTL(i) = Cells(127 + (j * i), 1).Value
Num_SerieCTL(i) = Cells(127 + (j * i), 2).Value
Date_ESCTL(i) = Cells(127 + (j * i), 3).Value
Date_CgtCTL(i) = Cells(127 + (j * i), 4).Value
Date_EssaiCTL(i) = Cells(127 + (j * i), 5).Value
Date_FinEssaisCTL(i) = Cells(127 + (j * i), 6).Value
Next i
'TRA1 à TRA3
j = 4
For i = 0 To 2
NumOF_TRA(i) = Cells(139 + (j * i), 1).Value
Nom_TRA(i) = Cells(139 + (j * i), 2).Value
Num_SerieTRA(i) = Cells(139 + (j * i), 3).Value
DateES_TRA(i) = Cells(139 + (j * i), 4).Value
Date_ChtTRA(i) = Cells(139 + (j * i), 5).Value
Date_EssaiTRA(i) = Cells(139 + (j * i), 6).Value
Date_FinEssaisTRA(i) = Cells(139 + (j * i), 7).Value
Type_TRA(i) = Cells(139 + (j * i), 8).Value
Type_NeutreTRA(i) = Cells(139 + (j * i), 9).Value
TypeTRA(i) = Cells(139 + (j * i), 10).Value
Next i
'AUTO
Num_OFAUTO = Cells(151, 1).Value
Num_AUTO = Cells(151, 2).Value
Date_ESAUTO = Cells(151, 3).Value
Date_ChtAUTO = Cells(151, 4).Value
Date_EssaisAUTO = Cells(151, 5).Value
Date_FinEssaisAUTO = Cells(151, 6).Value
TypeLotAUTO = Cells(151, 7).Value
'SUP
Num_SerieSup = Cells(155, 1).Value
Num_SerieIMP = Cells(155, 2).Value
Date_ESSUP = Cells(155, 3).Value
Date_ChtSUP = Cells(155, 4).Value
DateEssaiSUP = Cells(155, 5).Value
DateFinEssaiSUP = Cells(155, 6).Value
NumSerieTimeBox = Cells(155, 7).Value
'TCFM
Num_SerieTCFM = Cells(159, 1).Value
Date_ESTCFM = Cells(159, 2).Value
DateCgtTCFM = Cells(159, 3).Value
DateEssaiTCFM = Cells(159, 4).Value
DateFinEssaiTCFM = Cells(159, 5).Value
Sheets(Feuille).Protect
End Sub
'*********************************************************************************************************'
'*********************************************************************************************************'
Sub Affiche_Donnees_saisies()
Dim i As Integer
NomPoste = Nom_Poste
NomPoste.Enabled = False
NumOF = Num_OF
NumOF.Enabled = False
NumAR = Num_AR
NumAR.Enabled = False
DateEssais = DateEssai
DateEssais.Enabled = False
If DateFinEssai <> "" Then
FinEssais = DateFinEssai
FinEssais.Enabled = False
End If
If DateExpe <> "" Then
Expedition = DateExpe
Expedition.Enabled = False
End If
Calibre = Calibre48125
Calibre.Enabled = False
DateB2B5 = Date_B2B5
DateB2B5.Enabled = False
VersionB2B5 = Version_B2B5
VersionB2B5.Enabled = False
DateSUP = Date_SUP
DateSUP.Enabled = False
VersionSUP = Version_SUP
VersionSUP.Enabled = False
DateD82 = Date_D82
DateD82.Enabled = False
VersionD82 = Version_D82
VersionD82.Enabled = False
VCONFLOTAUTO = VCONFLOT_AUTO
VCONFLOTAUTO.Enabled = False
VCONFLOTTRA = VCONFLOT_TRA
VCONFLOTTRA.Enabled = False
VCONFLOTRAME = VCONFLOT_RAME
VCONFLOTRAME.Enabled = False
NbreTransfo = NbreTRA
NbreTransfo.Enabled = False
NbreCTL = Nbre_CTL
NbreCTL.Enabled = False
TCFM = ValTCFM
TCFM.Enabled = False
DateTCFM = DateRecepTCFM
DateTCFM.Enabled = False
VersionTCFM = Version_TCFM
VersionTCFM.Enabled = False
VersionCD = Version_CD
VersionCD.Enabled = False
VersionCDL = Version_CDL
VersionCDL.Enabled = False
VersionTMS = Version_TMS
VersionTMS.Enabled = False
For i = 0 To 14
MultiPage1.Pages(i).Enabled = True
MultiPage1.Value = i
Select Case i
Case 0: NomRame1 = UCase(tabNomRame(i)) 'rame1
NomRame1.Enabled = False
ARRIVEE1 = UCase(tabArrivee(i))
ARRIVEE1.Enabled = False
DA1 = UCase(tabDA(i))
DA1.Enabled = False
DS1 = UCase(tabDS(i))
DS1.Enabled = False
CD1 = UCase(tabCD(i))
CD1.Enabled = False
CP1 = UCase(tabCP(i))
CP1.Enabled = False
SH1 = UCase(tabSH(i))
SH1.Enabled = False
TypeNicerAR1.Caption = TabNicerARCDCPSH(i, 0)
TypeNicerAR1.Enabled = False
TypeNicerCD1.Caption = TabNicerARCDCPSH(i, 1)
TypeNicerCD1.Enabled = False
TypeNicerCP1.Caption = TabNicerARCDCPSH(i, 2)
TypeNicerCP1.Enabled = False
TypeNicerSH1.Caption = TabNicerARCDCPSH(i, 3)
TypeNicerSH1.Enabled = False
NomCelluleAR1 = tabNomCellAR(i)
NomCelluleAR1.Enabled = False
NumSerieAR1 = tabNumSerie_AR(i)
NumSerieAR1.Enabled = False
TypeNicer1 = tabTypeNICER(i, 0)
TypeNicer1.Enabled = False
TypeNicer2 = tabTypeNICER(i, 1)
TypeNicer2.Enabled = False
TypeNicer3 = tabTypeNICER(i, 2)
TypeNicer3.Enabled = False
TypeNicer4 = tabTypeNICER(i, 3)
TypeNicer4.Enabled = False
TypeNicer5 = tabTypeNICER(i, 4)
TypeNicer5.Enabled = False
TypeNicer6 = tabTypeNICER(i, 5)
TypeNicer6.Enabled = False
TypeNicer7 = tabTypeNICER(i, 6)
TypeNicer7.Enabled = False
TypeNicer8 = tabTypeNICER(i, 7)
TypeNicer8.Enabled = False
NomCelluleDep1 = tabNomCellDep(i, 0)
NomCelluleDep1.Enabled = False
NumSerieDep1 = tabNumSerie_Dep(i, 0)
NumSerieDep1.Enabled = False
NomCelluleDep2 = tabNomCellDep(i, 1)
NomCelluleDep2.Enabled = False
NumSerieDep2 = tabNumSerie_Dep(i, 1)
NumSerieDep2.Enabled = False
NomCelluleDep3 = tabNomCellDep(i, 2)
NomCelluleDep3.Enabled = False
NumSerieDep3 = tabNumSerie_Dep(i, 2)
NumSerieDep3.Enabled = False
NomCelluleDep4 = tabNomCellDep(i, 3)
NomCelluleDep4.Enabled = False
NumSerieDep4 = tabNumSerie_Dep(i, 3)
NumSerieDep4.Enabled = False
NomCelluleDep5 = tabNomCellDep(i, 4)
NomCelluleDep5.Enabled = False
NumSerieDep5 = tabNumSerie_Dep(i, 4)
NumSerieDep5.Enabled = False
NomCelluleDep6 = tabNomCellDep(i, 5)
NomCelluleDep6.Enabled = False
NumSerieDep6 = tabNumSerie_Dep(i, 5)
NumSerieDep6.Enabled = False
NomCelluleDep7 = tabNomCellDep(i, 6)
NomCelluleDep7.Enabled = False
NumSerieDep7 = tabNumSerie_Dep(i, 6)
NumSerieDep7.Enabled = False
NomCelluleDep8 = tabNomCellDep(i, 7)
NomCelluleDep8.Enabled = False
NumSerieDep8 = tabNumSerie_Dep(i, 7)
NumSerieDep8.Enabled = False
NomCelluleCD1 = tabNomCellCD(i)
NomCelluleCD1.Enabled = False
NumSerieCD1 = tabNumSerie_CD(i)
NumSerieCD1.Enabled = False
NomCelluleCP1 = tabNomCellCP(i)
NomCelluleCP1.Enabled = False
NumSerieCP1 = tabNumSerie_CP(i)
NumSerieCP1.Enabled = False
NomCelluleSH1 = tabNomCellSH(i)
NomCelluleSH1.Enabled = False
NumSerieSH1 = tabNumSerie_SH(i)
NumSerieSH1.Enabled = False
Case 1: NomRame2 = UCase(tabNomRame(i)) 'rame2
NomRame2.Enabled = False
ARRIVEE2 = UCase(tabArrivee(i))
ARRIVEE2.Enabled = False
DA2 = UCase(tabDA(i))
DA2.Enabled = False
DS2 = UCase(tabDS(i))
DS2.Enabled = False
CD2 = UCase(tabCD(i))
CD2.Enabled = False
CP2 = UCase(tabCP(i))
CP2.Enabled = False
SH2 = UCase(tabSH(i))
SH2.Enabled = False
TypeNicerAR2.Caption = TabNicerARCDCPSH(i, 0)
TypeNicerAR2.Enabled = False
TypeNicerCD2.Caption = TabNicerARCDCPSH(i, 1)
TypeNicerCD2.Enabled = False
TypeNicerCP2.Caption = TabNicerARCDCPSH(i, 2)
TypeNicerCP2.Enabled = False
TypeNicerSH2.Caption = TabNicerARCDCPSH(i, 3)
TypeNicerSH2.Enabled = False
NomCelluleAR2 = tabNomCellAR(i)
NomCelluleAR2.Enabled = False
NumSerieAR2 = tabNumSerie_AR(i)
NumSerieAR2.Enabled = False
TypeNicer1_2 = tabTypeNICER(i, 0)
TypeNicer1_2.Enabled = False
TypeNicer2_2 = tabTypeNICER(i, 1)
TypeNicer2_2.Enabled = False
TypeNicer3_2 = tabTypeNICER(i, 2)
TypeNicer3_2.Enabled = False
TypeNicer4_2 = tabTypeNICER(i, 3)
TypeNicer4_2.Enabled = False
TypeNicer5_2 = tabTypeNICER(i, 4)
TypeNicer5_2.Enabled = False
TypeNicer6_2 = tabTypeNICER(i, 5)
TypeNicer6_2.Enabled = False
TypeNicer7_2 = tabTypeNICER(i, 6)
TypeNicer7_2.Enabled = False
TypeNicer8_2 = tabTypeNICER(i, 7)
TypeNicer8_2.Enabled = False
NomCelluleDep1_2 = tabNomCellDep(i, 0)
NomCelluleDep1_2.Enabled = False
NumSerieDep1_2 = tabNumSerie_Dep(i, 0)
NumSerieDep1_2.Enabled = False
NomCelluleDep2_2 = tabNomCellDep(i, 1)
NomCelluleDep2_2.Enabled = False
NumSerieDep2_2 = tabNumSerie_Dep(i, 1)
NumSerieDep2_2.Enabled = False
NomCelluleDep3_2 = tabNomCellDep(i, 2)
NomCelluleDep3_2.Enabled = False
NumSerieDep3_2 = tabNumSerie_Dep(i, 2)
NumSerieDep3_2.Enabled = False
NomCelluleDep4_2 = tabNomCellDep(i, 3)
NomCelluleDep4_2.Enabled = False
NumSerieDep4_2 = tabNumSerie_Dep(i, 3)
NumSerieDep4_2.Enabled = False
NomCelluleDep5_2 = tabNomCellDep(i, 4)
NomCelluleDep5_2.Enabled = False
NumSerieDep5_2 = tabNumSerie_Dep(i, 4)
NumSerieDep5_2.Enabled = False
NomCelluleDep6_2 = tabNomCellDep(i, 5)
NomCelluleDep6_2.Enabled = False
NumSerieDep6_2 = tabNumSerie_Dep(i, 5)
NumSerieDep6_2.Enabled = False
NomCelluleDep7_2 = tabNomCellDep(i, 6)
NomCelluleDep7_2.Enabled = False
NumSerieDep7_2 = tabNumSerie_Dep(i, 6)
NumSerieDep7_2.Enabled = False
NomCelluleDep8_2 = tabNomCellDep(i, 7)
NomCelluleDep8_2.Enabled = False
NumSerieDep8_2 = tabNumSerie_Dep(i, 7)
NumSerieDep8_2.Enabled = False
NomCelluleCD2 = tabNomCellCD(i)
NomCelluleCD2.Enabled = False
NumSerieCD2 = tabNumSerie_CD(i)
NumSerieCD2.Enabled = False
NomCelluleCP2 = tabNomCellCP(i)
NomCelluleCP2.Enabled = False
NumSerieCP2 = tabNumSerie_CP(i)
NumSerieCP2.Enabled = False
NomCelluleSH2 = tabNomCellSH(i)
NomCelluleSH2.Enabled = False
NumSerieSH2 = tabNumSerie_SH(i)
NumSerieSH2.Enabled = False
Case 2: NomRame3 = UCase(tabNomRame(i)) 'rame3
NomRame3.Enabled = False
ARRIVEE3 = UCase(tabArrivee(i))
ARRIVEE3.Enabled = False
DA3 = UCase(tabDA(i))
DA3.Enabled = False
DS3 = UCase(tabDS(i))
DS3.Enabled = False
CD3 = UCase(tabCD(i))
CD3.Enabled = False
CP3 = UCase(tabCP(i))
CP3.Enabled = False
SH3 = UCase(tabSH(i))
SH3.Enabled = False
TypeNicerAR3.Caption = TabNicerARCDCPSH(i, 0)
TypeNicerAR3.Enabled = False
TypeNicerCD3.Caption = TabNicerARCDCPSH(i, 1)
TypeNicerCD3.Enabled = False
TypeNicerCP3.Caption = TabNicerARCDCPSH(i, 2)
TypeNicerCP3.Enabled = False
TypeNicerSH3.Caption = TabNicerARCDCPSH(i, 3)
TypeNicerSH3.Enabled = False
NomCelluleAR3 = tabNomCellAR(i)
NomCelluleAR3.Enabled = False
NumSerieAR3 = tabNumSerie_AR(i)
NumSerieAR3.Enabled = False
TypeNicer1_3 = tabTypeNICER(i, 0)
TypeNicer1_3.Enabled = False
TypeNicer2_3 = tabTypeNICER(i, 1)
TypeNicer2_3.Enabled = False
TypeNicer3_3 = tabTypeNICER(i, 2)
TypeNicer3_3.Enabled = False
TypeNicer4_3 = tabTypeNICER(i, 3)
TypeNicer4_3.Enabled = False
TypeNicer5_3 = tabTypeNICER(i, 4)
TypeNicer5_3.Enabled = False
TypeNicer6_3 = tabTypeNICER(i, 5)
TypeNicer6_3.Enabled = False
TypeNicer7_3 = tabTypeNICER(i, 6)
TypeNicer7_3.Enabled = False
TypeNicer8_3 = tabTypeNICER(i, 7)
TypeNicer8_3.Enabled = False
NomCelluleDep1_3 = tabNomCellDep(i, 0)
NomCelluleDep1_3.Enabled = False
NumSerieDep1_3 = tabNumSerie_Dep(i, 0)
NumSerieDep1_3.Enabled = False
NomCelluleDep2_3 = tabNomCellDep(i, 1)
NomCelluleDep2_3.Enabled = False
NumSerieDep2_3 = tabNumSerie_Dep(i, 1)
NumSerieDep2_3.Enabled = False
NomCelluleDep3_3 = tabNomCellDep(i, 2)
NomCelluleDep3_3.Enabled = False
NumSerieDep3_3 = tabNumSerie_Dep(i, 2)
NumSerieDep3_3.Enabled = False
NomCelluleDep4_3 = tabNomCellDep(i, 3)
NomCelluleDep4_3.Enabled = False
NumSerieDep4_3 = tabNumSerie_Dep(i, 3)
NumSerieDep4_3.Enabled = False
NomCelluleDep5_3 = tabNomCellDep(i, 4)
NomCelluleDep5_3.Enabled = False
NumSerieDep5_3 = tabNumSerie_Dep(i, 4)
NumSerieDep5_3.Enabled = False
NomCelluleDep6_3 = tabNomCellDep(i, 5)
NomCelluleDep6_3.Enabled = False
NumSerieDep6_3 = tabNumSerie_Dep(i, 5)
NumSerieDep6_3.Enabled = False
NomCelluleDep7_3 = tabNomCellDep(i, 6)
NomCelluleDep7_3.Enabled = False
NumSerieDep7_3 = tabNumSerie_Dep(i, 6)
NumSerieDep7_3.Enabled = False
NomCelluleDep8_3 = tabNomCellDep(i, 7)
NomCelluleDep8_3.Enabled = False
NumSerieDep8_3 = tabNumSerie_Dep(i, 7)
NumSerieDep8_3.Enabled = False
NomCelluleCD3 = tabNomCellCD(i)
NomCelluleCD3.Enabled = False
NumSerieCD3 = tabNumSerie_CD(i)
NumSerieCD3.Enabled = False
NomCelluleCP3 = tabNomCellCP(i)
NomCelluleCP3.Enabled = False
NumSerieCP3 = tabNumSerie_CP(i)
NumSerieCP3.Enabled = False
NomCelluleSH3 = tabNomCellSH(i)
NomCelluleSH3.Enabled = False
NumSerieSH3 = tabNumSerie_SH(i)
NumSerieSH3.Enabled = False
Case 3: NomRame4 = UCase(tabNomRame(i)) 'rame4
NomRame4.Enabled = False
ARRIVEE4 = UCase(tabArrivee(i))
ARRIVEE4.Enabled = False
DA4 = UCase(tabDA(i))
DA4.Enabled = False
DS4 = UCase(tabDS(i))
DS4.Enabled = False
CD4 = UCase(tabCD(i))
CD4.Enabled = False
CP4 = UCase(tabCP(i))
CP4.Enabled = False
SH4 = UCase(tabSH(i))
SH4.Enabled = False
TypeNicerAR4.Caption = TabNicerARCDCPSH(i, 0)
TypeNicerAR4.Enabled = False
TypeNicerCD4.Caption = TabNicerARCDCPSH(i, 1)
TypeNicerCD4.Enabled = False
TypeNicerCP4.Caption = TabNicerARCDCPSH(i, 2)
TypeNicerCP4.Enabled = False
TypeNicerSH4.Caption = TabNicerARCDCPSH(i, 3)
TypeNicerSH4.Enabled = False
NomCelluleAR4 = tabNomCellAR(i)
NomCelluleAR4.Enabled = False
NumSerieAR4 = tabNumSerie_AR(i)
NumSerieAR4.Enabled = False
TypeNicer1_4 = tabTypeNICER(i, 0)
TypeNicer1_4.Enabled = False
TypeNicer2_4 = tabTypeNICER(i, 1)
TypeNicer2_4.Enabled = False
TypeNicer3_4 = tabTypeNICER(i, 2)
TypeNicer3_4.Enabled = False
TypeNicer4_4 = tabTypeNICER(i, 3)
TypeNicer4_4.Enabled = False
TypeNicer5_4 = tabTypeNICER(i, 4)
TypeNicer5_4.Enabled = False
TypeNicer6_4 = tabTypeNICER(i, 5)
TypeNicer6_4.Enabled = False
TypeNicer7_4 = tabTypeNICER(i, 6)
TypeNicer7_4.Enabled = False
TypeNicer8_4 = tabTypeNICER(i, 7)
TypeNicer8_4.Enabled = False
NomCelluleDep1_4 = tabNomCellDep(i, 0)
NomCelluleDep1_4.Enabled = False
NumSerieDep1_4 = tabNumSerie_Dep(i, 0)
NumSerieDep1_4.Enabled = False
NomCelluleDep2_4 = tabNomCellDep(i, 1)
NomCelluleDep2_4.Enabled = False
NumSerieDep2_4 = tabNumSerie_Dep(i, 1)
NumSerieDep2_4.Enabled = False
NomCelluleDep3_4 = tabNomCellDep(i, 2)
NomCelluleDep3_4.Enabled = False
NumSerieDep3_4 = tabNumSerie_Dep(i, 2)
NumSerieDep3_4.Enabled = False
NomCelluleDep4_4 = tabNomCellDep(i, 3)
NomCelluleDep4_4.Enabled = False
NumSerieDep4_4 = tabNumSerie_Dep(i, 3)
NumSerieDep4_4.Enabled = False
NomCelluleDep5_4 = tabNomCellDep(i, 4)
NomCelluleDep5_4.Enabled = False
NumSerieDep5_4 = tabNumSerie_Dep(i, 4)
NumSerieDep5_4.Enabled = False
NomCelluleDep6_4 = tabNomCellDep(i, 5)
NomCelluleDep6_4.Enabled = False
NumSerieDep6_4 = tabNumSerie_Dep(i, 5)
NumSerieDep6_4.Enabled = False
NomCelluleDep7_4 = tabNomCellDep(i, 6)
NomCelluleDep7_4.Enabled = False
NumSerieDep7_4 = tabNumSerie_Dep(i, 6)
NumSerieDep7_4.Enabled = False
NomCelluleDep8_4 = tabNomCellDep(i, 7)
NomCelluleDep8_4.Enabled = False
NumSerieDep8_4 = tabNumSerie_Dep(i, 7)
NumSerieDep8_4.Enabled = False
NomCelluleCD4 = tabNomCellCD(i)
NomCelluleCD4.Enabled = False
NumSerieCD4 = tabNumSerie_CD(i)
NumSerieCD4.Enabled = False
NomCelluleCP4 = tabNomCellCP(i)
NomCelluleCP4.Enabled = False
NumSerieCP4 = tabNumSerie_CP(i)
NumSerieCP4.Enabled = False
NomCelluleSH4 = tabNomCellSH(i)
NomCelluleSH4.Enabled = False
NumSerieSH4 = tabNumSerie_SH(i)
NumSerieSH4.Enabled = False
Case 4: NomRame5 = UCase(tabNomRame(i)) 'rame5
NomRame5.Enabled = False
ARRIVEE5 = UCase(tabArrivee(i))
ARRIVEE5.Enabled = False
DA5 = UCase(tabDA(i))
DA5.Enabled = False
DS5 = UCase(tabDS(i))
DS5.Enabled = False
CD5 = UCase(tabCD(i))
CD5.Enabled = False
CP5 = UCase(tabCP(i))
CP5.Enabled = False
SH5 = UCase(tabSH(i))
SH5.Enabled = False
TypeNicerAR5.Caption = TabNicerARCDCPSH(i, 0)
TypeNicerAR5.Enabled = False
TypeNicerCD5.Caption = TabNicerARCDCPSH(i, 1)
TypeNicerCD5.Enabled = False
TypeNicerCP5.Caption = TabNicerARCDCPSH(i, 2)
TypeNicerCP5.Enabled = False
TypeNicerSH5.Caption = TabNicerARCDCPSH(i, 3)
TypeNicerSH5.Enabled = False
NomCelluleAR5 = tabNomCellAR(i)
NomCelluleAR5.Enabled = False
NumSerieAR5 = tabNumSerie_AR(i)
NumSerieAR5.Enabled = False
TypeNicer1_5 = tabTypeNICER(i, 0)
TypeNicer1_5.Enabled = False
TypeNicer2_5 = tabTypeNICER(i, 1)
TypeNicer2_5.Enabled = False
TypeNicer3_5 = tabTypeNICER(i, 2)
TypeNicer3_5.Enabled = False
TypeNicer4_5 = tabTypeNICER(i, 3)
TypeNicer4_5.Enabled = False
TypeNicer5_5 = tabTypeNICER(i, 4)
TypeNicer5_5.Enabled = False
TypeNicer6_5 = tabTypeNICER(i, 5)
TypeNicer6_5.Enabled = False
TypeNicer7_5 = tabTypeNICER(i, 6)
TypeNicer7_5.Enabled = False
TypeNicer8_5 = tabTypeNICER(i, 7)
TypeNicer8_5.Enabled = False
NomCelluleDep1_5 = tabNomCellDep(i, 0)
NomCelluleDep1_5.Enabled = False
NumSerieDep1_5 = tabNumSerie_Dep(i, 0)
NumSerieDep1_5.Enabled = False
NomCelluleDep2_5 = tabNomCellDep(i, 1)
NomCelluleDep2_5.Enabled = False
NumSerieDep2_5 = tabNumSerie_Dep(i, 1)
NumSerieDep2_5.Enabled = False
NomCelluleDep3_5 = tabNomCellDep(i, 2)
NomCelluleDep3_5.Enabled = False
NumSerieDep3_5 = tabNumSerie_Dep(i, 2)
NumSerieDep3_5.Enabled = False
NomCelluleDep4_5 = tabNomCellDep(i, 3)
NomCelluleDep4_5.Enabled = False
NumSerieDep4_5 = tabNumSerie_Dep(i, 3)
NumSerieDep4_5.Enabled = False
NomCelluleDep5_5 = tabNomCellDep(i, 4)
NomCelluleDep5_5.Enabled = False
NumSerieDep5_5 = tabNumSerie_Dep(i, 4)
NumSerieDep5_5.Enabled = False
NomCelluleDep6_5 = tabNomCellDep(i, 5)
NomCelluleDep6_5.Enabled = False
NumSerieDep6_5 = tabNumSerie_Dep(i, 5)
NumSerieDep6_5.Enabled = False
NomCelluleDep7_5 = tabNomCellDep(i, 6)
NomCelluleDep7_5.Enabled = False
NumSerieDep7_5 = tabNumSerie_Dep(i, 6)
NumSerieDep7_5.Enabled = False
NomCelluleDep8_5 = tabNomCellDep(i, 7)
NomCelluleDep8_5.Enabled = False
NumSerieDep8_5 = tabNumSerie_Dep(i, 7)
NumSerieDep8_5.Enabled = False
NomCelluleCD5 = tabNomCellCD(i)
NomCelluleCD5.Enabled = False
NumSerieCD5 = tabNumSerie_CD(i)
NumSerieCD5.Enabled = False
NomCelluleCP5 = tabNomCellCP(i)
NomCelluleCP5.Enabled = False
NumSerieCP5 = tabNumSerie_CP(i)
NumSerieCP5.Enabled = False
NomCelluleSH5 = tabNomCellSH(i)
NomCelluleSH5.Enabled = False
NumSerieSH5 = tabNumSerie_SH(i)
NumSerieSH5.Enabled = False
Case 5: NomRame6 = UCase(tabNomRame(i)) 'rame6
NomRame6.Enabled = False
ARRIVEE6 = UCase(tabArrivee(i))
ARRIVEE6.Enabled = False
DA6 = UCase(tabDA(i))
DA6.Enabled = False
DS6 = UCase(tabDS(i))
DS6.Enabled = False
CD6 = UCase(tabCD(i))
CD6.Enabled = False
CP6 = UCase(tabCP(i))
CP6.Enabled = False
SH6 = UCase(tabSH(i))
SH6.Enabled = False
TypeNicerAR6.Caption = TabNicerARCDCPSH(i, 0)
TypeNicerAR6.Enabled = False
TypeNicerCD6.Caption = TabNicerARCDCPSH(i, 1)
TypeNicerCD6.Enabled = False
TypeNicerCP6.Caption = TabNicerARCDCPSH(i, 2)
TypeNicerCP6.Enabled = False
TypeNicerSH6.Caption = TabNicerARCDCPSH(i, 3)
TypeNicerSH6.Enabled = False
NomCelluleAR6 = tabNomCellAR(i)
NomCelluleAR6.Enabled = False
NumSerieAR6 = tabNumSerie_AR(i)
NumSerieAR6.Enabled = False
TypeNicer1_6 = tabTypeNICER(i, 0)
TypeNicer1_6.Enabled = False
TypeNicer2_6 = tabTypeNICER(i, 1)
TypeNicer2_6.Enabled = False
TypeNicer3_6 = tabTypeNICER(i, 2)
TypeNicer3_6.Enabled = False
TypeNicer4_6 = tabTypeNICER(i, 3)
TypeNicer4_6.Enabled = False
TypeNicer5_6 = tabTypeNICER(i, 4)
TypeNicer5_6.Enabled = False
TypeNicer6_6 = tabTypeNICER(i, 5)
TypeNicer6_6.Enabled = False
TypeNicer7_6 = tabTypeNICER(i, 6)
TypeNicer7_6.Enabled = False
TypeNicer8_6 = tabTypeNICER(i, 7)
TypeNicer8_6.Enabled = False
NomCelluleDep1_6 = tabNomCellDep(i, 0)
NomCelluleDep1_6.Enabled = False
NumSerieDep1_6 = tabNumSerie_Dep(i, 0)
NumSerieDep1_6.Enabled = False
NomCelluleDep2_6 = tabNomCellDep(i, 1)
NomCelluleDep2_6.Enabled = False
NumSerieDep2_6 = tabNumSerie_Dep(i, 1)
NumSerieDep2_6.Enabled = False
NomCelluleDep3_6 = tabNomCellDep(i, 2)
NomCelluleDep3_6.Enabled = False
NumSerieDep3_6 = tabNumSerie_Dep(i, 2)
NumSerieDep3_6.Enabled = False
NomCelluleDep4_6 = tabNomCellDep(i, 3)
NomCelluleDep4_6.Enabled = False
NumSerieDep4_6 = tabNumSerie_Dep(i, 3)
NumSerieDep4_6.Enabled = False
NomCelluleDep5_6 = tabNomCellDep(i, 4)
NomCelluleDep5_6.Enabled = False
NumSerieDep5_6 = tabNumSerie_Dep(i, 4)
NumSerieDep5_6.Enabled = False
NomCelluleDep6_6 = tabNomCellDep(i, 5)
NomCelluleDep6_6.Enabled = False
NumSerieDep6_6 = tabNumSerie_Dep(i, 5)
NumSerieDep6_6.Enabled = False
NomCelluleDep7_6 = tabNomCellDep(i, 6)
NomCelluleDep7_6.Enabled = False
NumSerieDep7_6 = tabNumSerie_Dep(i, 6)
NumSerieDep7_6.Enabled = False
NomCelluleDep8_6 = tabNomCellDep(i, 7)
NomCelluleDep8_6.Enabled = False
NumSerieDep8_6 = tabNumSerie_Dep(i, 7)
NumSerieDep8_6.Enabled = False
NomCelluleCD6 = tabNomCellCD(i)
NomCelluleCD6.Enabled = False
NumSerieCD6 = tabNumSerie_CD(i)
NumSerieCD6.Enabled = False
NomCelluleCP6 = tabNomCellCP(i)
NomCelluleCP6.Enabled = False
NumSerieCP6 = tabNumSerie_CP(i)
NumSerieCP6.Enabled = False
NomCelluleSH6 = tabNomCellSH(i)
NomCelluleSH6.Enabled = False
NumSerieSH6 = tabNumSerie_SH(i)
NumSerieSH6.Enabled = False
Case 6: NumOFCTL1 = Num_OFCTL(0) 'ctl1
NumOFCTL1.Enabled = False
NumSerieCTL1 = Num_SerieCTL(0)
NumSerieCTL1.Enabled = False
If Date_ESCTL(0) <> "" Then
DateMESCTL1 = Date_ESCTL(0)
DateMESCTL1.Enabled = False
End If
If Date_CgtCTL(0) <> "" Then
DateCgtCTL1 = Date_CgtCTL(0)
DateCgtCTL1.Enabled = False
End If
If Date_EssaiCTL(0) <> "" Then
DateEssaiCTL1 = Date_EssaiCTL(0)
DateEssaiCTL1.Enabled = False
End If
If Date_FinEssaisCTL(0) <> "" Then
DateFinEssaisCTL1 = Date_FinEssaisCTL(0)
DateFinEssaisCTL1.Enabled = False
End If
Case 7: NumOFCTL2 = Num_OFCTL(1) 'ctl2
NumOFCTL2.Enabled = False
NumSerieCTL2 = Num_SerieCTL(1)
NumSerieCTL2.Enabled = False
If Date_ESCTL(1) <> "" Then
DateMESCTL2 = Date_ESCTL(1)
DateMESCTL2.Enabled = False
End If
If Date_CgtCTL(1) <> "" Then
DateCgtCTL2 = Date_CgtCTL(1)
DateCgtCTL2.Enabled = False
End If
If Date_EssaiCTL(1) <> "" Then
DateEssaiCTL2 = Date_EssaiCTL(1)
DateEssaiCTL2.Enabled = False
End If
If Date_FinEssaisCTL(1) <> "" Then
DateFinEssaisCTL2 = Date_FinEssaisCTL(1)
DateFinEssaisCTL2.Enabled = False
End If
Case 8: NumOFCTL3 = Num_OFCTL(2) 'ctl3
NumOFCTL3.Enabled = False
NumSerieCTL3 = Num_SerieCTL(2)
NumSerieCTL3.Enabled = False
If Date_ESCTL(2) <> "" Then
DateMESCTL3 = Date_ESCTL(2)
DateMESCTL3.Enabled = False
End If
If Date_CgtCTL(2) <> "" Then
DateCgtCTL3 = Date_CgtCTL(2)
DateCgtCTL3.Enabled = False
End If
If Date_EssaiCTL(2) <> "" Then
DateEssaiCTL3 = Date_EssaiCTL(2)
DateEssaiCTL3.Enabled = False
End If
If Date_FinEssaisCTL(2) <> "" Then
DateFinEssaisCTL3 = Date_FinEssaisCTL(2)
DateFinEssaisCTL3.Enabled = False
End If
Case 9: NumOFTRA1 = NumOF_TRA(0) 'tra1
NumOFTRA1.Enabled = False
NomTRA1 = Nom_TRA(0)
NomTRA1.Enabled = False
NumSerieTRA1 = Num_SerieTRA(0)
NumSerieTRA1.Enabled = False
If DateES_TRA(0) <> "" Then
DateESTRA1 = DateES_TRA(0)
DateESTRA1.Enabled = False
End If
If Date_ChtTRA(0) <> "" Then
DateChtTRA1 = Date_ChtTRA(0)
DateChtTRA1.Enabled = False
End If
If Date_EssaiTRA(0) <> "" Then
DateEssaisTRA1 = Date_EssaiTRA(0)
DateEssaisTRA1.Enabled = False
End If
If Date_FinEssaisTRA(0) <> "" Then
DateFinEssaisTRA1 = Date_FinEssaisTRA(0)
DateFinEssaisTRA1.Enabled = False
End If
TypeLotTRA1 = Type_TRA(0)
TypeLotTRA1.Enabled = False
TypeNeutreTRA1 = Type_NeutreTRA(0)
TypeNeutreTRA1.Enabled = False
TypeTRA1 = TypeTRA(0)
TypeTRA1.Enabled = False
Case 10: NumOFTRA2 = NumOF_TRA(1) 'tra2
NumOFTRA2.Enabled = False
NomTRA2 = Nom_TRA(1)
NomTRA2.Enabled = False
NumSerieTRA2 = Num_SerieTRA(1)
NumSerieTRA2.Enabled = False
If DateES_TRA(1) <> "" Then
DateESTRA2 = DateES_TRA(1)
DateESTRA2.Enabled = False
End If
If Date_ChtTRA(1) <> "" Then
DateChtTRA2 = Date_ChtTRA(1)
DateChtTRA2.Enabled = False
End If
If Date_EssaiTRA(1) <> "" Then
DateEssaisTRA2 = Date_EssaiTRA(1)
DateEssaisTRA2.Enabled = False
End If
If Date_FinEssaisTRA(1) <> "" Then
DateFinEssaisTRA2 = Date_FinEssaisTRA(1)
DateFinEssaisTRA2.Enabled = False
End If
TypeLotTRA2 = Type_TRA(1)
TypeLotTRA2.Enabled = False
TypeNeutreTRA2 = Type_NeutreTRA(1)
TypeNeutreTRA2.Enabled = False
TypeTRA2 = TypeTRA(1)
TypeTRA2.Enabled = False
Case 11: NumOFTRA3 = NumOF_TRA(2) 'tra3
NumOFTRA3.Enabled = False
NomTRA3 = Nom_TRA(2)
NomTRA3.Enabled = False
NumSerieTRA3 = Num_SerieTRA(2)
NumSerieTRA3.Enabled = False
If DateES_TRA(2) <> "" Then
DateESTRA3 = DateES_TRA(2)
DateESTRA3.Enabled = False
End If
If Date_ChtTRA(2) <> "" Then
DateChtTRA3 = Date_ChtTRA(2)
DateChtTRA3.Enabled = False
End If
If Date_EssaiTRA(2) <> "" Then
DateEssaisTRA3 = Date_EssaiTRA(2)
DateEssaisTRA3.Enabled = False
End If
If Date_FinEssaisTRA(2) <> "" Then
DateFinEssaisTRA3 = Date_FinEssaisTRA(2)
DateFinEssaisTRA3.Enabled = False
End If
TypeLotTRA3 = Type_TRA(2)
TypeLotTRA3.Enabled = False
TypeNeutreTRA3 = Type_NeutreTRA(2)
TypeNeutreTRA3.Enabled = False
TypeTRA3 = TypeTRA(2)
TypeTRA3.Enabled = False
Case 12: NumOFAUTO = Num_OFAUTO 'AUTO
NumOFAUTO.Enabled = False
NumSerieAUTO = Num_AUTO
NumSerieAUTO.Enabled = False
DateESAUTO = Date_ESAUTO
DateESAUTO.Enabled = False
DateChtAUTO = Date_ChtAUTO
DateChtAUTO.Enabled = False
DateEssaisAUTO = Date_EssaisAUTO
DateEssaisAUTO.Enabled = False
If Date_FinEssaisAUTO <> "" Then
DateFinEssaisAUTO = Date_FinEssaisAUTO
DateFinEssaisAUTO.Enabled = False
End If
TypeAUTO = TypeLotAUTO
TypeAUTO.Enabled = False
Case 13: NumSerieSUP = Num_SerieSup 'SUP
NumSerieSUP.Enabled = False
NumSerieImp = Num_SerieIMP
NumSerieImp.Enabled = False
DateESSUP = Date_ESSUP
DateESSUP.Enabled = False
DateChtSUP = Date_ChtSUP
DateChtSUP.Enabled = False
DateEssaisSUP = DateEssaiSUP
DateEssaisSUP.Enabled = False
If DateFinEssaiSUP <> "" Then
DateFinEssaisSUP = DateFinEssaiSUP
DateFinEssaisSUP.Enabled = False
End If
TimeBOX = NumSerieTimeBox
TimeBOX.Enabled = False
Case 14: NumSerieTCFM = Num_SerieTCFM 'TCFM
NumSerieTCFM.Enabled = False
DateESTCFM = Date_ESTCFM
DateESTCFM.Enabled = False
DateChtTCFM = DateCgtTCFM
DateChtTCFM.Enabled = False
DateEssaisTCFM = DateEssaiTCFM
DateEssaisTCFM.Enabled = False
If DateFinEssaiTCFM <> "" Then
DateFinEssaisTCFM = DateFinEssaiTCFM
DateFinEssaisTCFM.Enabled = False
End If
End Select
Next i
End Sub
'*********************************************************************************************************'
'*********************************************************************************************************'
Sub Affiche_Donnees()
Worksheets("Données").Visible = True
Sheets("Données").Select
Sheets("Données").Unprotect
If Cells(2, 2) <> "" Then
PREPAREPV.Enabled = False
End If
If PREPAREPV.Enabled = False Then 'désactiver
Worksheets("Données").Visible = True
Call Lecture_donnees
Call Affiche_Donnees_saisies
GENEREPVCLIENT.Enabled = True
Worksheets("Données").Visible = xlSheetHidden
End If
If PREPAREPV.Enabled = True Then 'activer
Worksheets("Données").Visible = True
End If
End Sub
'*********************************************************************************************************'