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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78
| Private Sub ajouter_Click()
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim n As Integer
If ajoutclient.jour = "" Or ajoutclient.operateur = "" Or ajoutclient.poste = "" Or ajoutclient.reference = "" Or ajoutclient.temps_production = "" Or ajoutclient.quantite = "" Then
MsgBox "merci de remplir tout les champs"
Else
i = 2
Do While Cells(i, 1) <> ""
Cells(i, 1).Offset(1, 0).Select
i = i + 1
Loop
ActiveCell.Value = ajoutclient.jour.Value
ActiveCell.Offset(0, 1).Value = ajoutclient.operateur.Value
ActiveCell.Offset(0, 2).Value = ajoutclient.poste.Value
ActiveCell.Offset(0, 3).Value = ajoutclient.reference.Value
ActiveCell.Offset(0, 4).Value = ajoutclient.temps_production.Value
ActiveCell.Offset(0, 5).Value = ajoutclient.quantite.Value
Unload ajoutclient
End If
End Sub
Private Sub annuler_Click()
ajoutclient.Hide
End Sub
Private Sub Image1_Click()
End Sub
Private Sub jour_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)
End Sub
Private Sub Label5_Click()
End Sub
Private Sub Label7_Click()
End Sub
Private Sub operateur_Change()
End Sub
Private Sub UserForm_Initialize()
Dim i As Integer
i = 1
Do While Worksheets("postes").Cells(i, 1) <> ""
poste.AddItem Worksheets("postes").Cells(i, 1)
i = i + 1
Loop
Dim j As Integer
j = 1
Do While Worksheets("references").Cells(j, 1) <> ""
reference.AddItem Worksheets("references").Cells(j, 1)
j = j + 1
Loop
Dim k As Integer
k = 1
Do While Worksheets("operateurs").Cells(k, 1) <> ""
operateur.AddItem Worksheets("operateurs").Cells(k, 1)
k = k + 1
Loop
End Sub |
Partager