1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| Private Sub CBok_Click()
With Worksheets(1)
derlign = .Range("a65536").End(xlUp).Row + 1
.Cells(derlign, 1).Value = CBclient.Value 'Nom du client
.Cells(derlign, 2).Value = TBcodearticle.Value 'Code article
.Cells(derlign, 3).Value = TBof.Value 'of
.Cells(derlign, 4).Value = TBind.Value 'Désignation
''''''''''''''''''''''''''''Choix du setceur'''''''''''''''''''''''''''''''''
If OBstructure.Value = True Then
Cells(derlign, 5) = OBstructure.Caption
End If
If OBmecanosoude.Value = True Then
Cells(derlign, 5) = OBmecanosoude.Caption
End If
If OBchaudronnerie.Value = True Then
Cells(derlign, 5) = OBchaudronnerie.Caption
End If
''''''''''''''''''''''''''''Choix du type d'opération(s)'''''''''''''''''''''
If CheckBox9.Value = True Then Cells(derlign, 6) = CheckBox9.Caption
If CheckBox10.Value = True Then Cells(derlign, 6) = CheckBox10.Caption
If CheckBox11.Value = True Then Cells(derlign, 6) = CheckBox11.Caption
If CheckBox12.Value = True Then Cells(derlign, 6) = CheckBox12.Caption
If CheckBox13.Value = True Then Cells(derlign, 6) = CheckBox13.Caption
If CheckBox14.Value = True Then Cells(derlign, 6) = CheckBox14.Caption
If CheckBox15.Value = True Then Cells(derlign, 6) = CheckBox15.Caption
If CheckBox16.Value = True Then Cells(derlign, 6) = CheckBox16.Caption
End With |
Partager