Sub test2()
'pour rentrer les nouvelles éprouvettes
'définition des variables
Dim Client As String, RealisePar As String, LieuFabriq As String
Dim Fabriquant As String, Serrage As String, Eprouvette As String
Dim Dosage As String, Lieu As String, Projet As String
Dim Affaissement(12) As Long
Dim NbreEprouvette(3) As String, AgeEprouvette(3) As String, ref As String
Dim adr As String, N°Eprouvette As String, Partie As String
Dim DateReception As Date, DatePrelevement As Date
Dim ii As Integer, zz As Integer, yy As Integer
'Appel de L'userform3
UserForm3.Show
'enregistrement des données "date" et définitions des variables tableaux
NbreEprouvette1 = UserForm3.ComboBox1.Text
NbreEprouvette2 = UserForm3.ComboBox3.Text
NbreEprouvette3 = UserForm3.ComboBox5.Text
AgeEprouvette1 = UserForm3.ComboBox2.Text
AgeEprouvette2 = UserForm3.ComboBox4.Text
AgeEprouvette3 = UserForm3.ComboBox6.Text
DateReception = UserForm3.TextBox1.Text
DatePrelevement = UserForm3.TextBox2.Text
Affaissement1 = UserForm3.TextBox24.Text
Affaissement2 = UserForm3.TextBox25.Text
Affaissement3 = UserForm3.TextBox26.Text
Affaissement4 = UserForm3.TextBox27.Text
Affaissement5 = UserForm3.TextBox28.Text
Affaissement6 = UserForm3.TextBox29.Text
Affaissement7 = UserForm3.TextBox30.Text
Affaissement8 = UserForm3.TextBox31.Text
Affaissement9 = UserForm3.TextBox32.Text
Affaissement10 = UserForm3.TextBox33.Text
Affaissement11 = UserForm3.TextBox34.Text
Affaissement12 = UserForm3.TextBox35.Text
With Sheets("Carnet").Unprotect
End With
'on recherche le N° de la ligne de la cellule vide
With Sheets("Carnet").Range("A:A")
Set c = .Find("", LookIn:=xlValues)
If Not c Is Nothing Then
Do
adr = c.Address
Range(adr).Activate
'on défini ii avec le N° de la ligne adr
ii = ActiveCell.Row
Loop While c Is Nothing
End If
'on regarde si il a quelques chose de noté dans Eprouvette1
If NbreEprouvette1 = "" Then
GoTo Epreuve2
End If
If NbreEprouvette1 > 0 Then
'on colle les données de l'userform dans les cellules concernées
.Range("B" & ii) = UserForm3.ComboBox7.Text 'Client
.Range("I" & ii) = UserForm3.TextBox3.Text 'RealisePar
.Range("J" & ii) = UserForm3.ComboBox10.Text 'LieuFabriq
.Range("AC" & ii) = UserForm3.ComboBox11.Text 'Fabriquant
.Range("H" & ii) = UserForm3.ComboBox9.Text 'Serrage
.Range("G" & ii) = Eprouvette 'Eprouvette
.Range("S" & ii) = UserForm3.ComboBox12.Text 'Dosage
.Range("T" & ii) = UserForm3.TextBox9.Text 'Lieu
.Range("U" & ii) = UserForm3.TextBox10.Text 'Projet
.Range("V" & ii) = UserForm3.TextBox11.Text 'Partie
.Range("C" & ii) = DateReception 'DateReception
.Range("F" & ii) = DatePrelevement - 0 'DatePrelevement
.Range("W" & ii) = Affaissement1 'Affaissement
.Range("K" & ii) = UserForm3.TextBox12.Text 'N°Eprouvette
.Range("L" & ii) = AgeEprouvette1 'AgeEprouvette
'définition de la référence
z = 1
ref = Format(Range("C" & ii), "yymmdd" & "00")
yy = CDate(DateReception)
If yy = Range("C" & ii - 1).Value Then
.Range("A" & ii) = Range("c" & ii - 1) + 1 'ça ne fonctionne pas
End If
If yy <> Range("C" & ii - 1).Value Then
.Range("A" & ii) = ref + z
End If
If NbreEprouvette1 > 1 Then