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
If Range("C" & ii - 1).Value = Range("C" & ii).Value Then
.Range("A" & ii) = Range("A" & ii - 1) + "1"
End If
If Range("C" & ii - 1).Value <> Range("C" & ii).Value Then
.Range("A" & ii) = Format(Range("C" & ii), "yymmdd" & "01")
End If
If NbreEprouvette1 > 1 Then
'on colle les donnŽes de l'userform dans les cellules concernŽes
ii = ii + 1
.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) = Affaissement2 'Affaissement
.Range("K" & ii) = UserForm3.TextBox13.Text 'N¡Eprouvette
.Range("L" & ii) = AgeEprouvette1 'AgeEprouvette
'dŽfinition de la rŽfŽrence
If Range("C" & ii - 1).Value = Range("C" & ii).Value Then
.Range("A" & ii) = Range("A" & ii - 1) + 1
End If
If Range("C" & ii - 1).Value <> Range("C" & ii).Value Then
.Range("A" & ii) = Format(Range("C" & ii), "yymmdd" & "01")
End If
If NbreEprouvette1 > 2 Then
ii = ii + 1
'etc...