1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Public Sub Confiramtion_Click()
SPCheckBox
MsgBox (selectioncase)
Cellule(1, 1) = CorpsDeclarations.ExpediteurNom.Text
Cellule(1, 2) = CorpsDeclarations.ExpediteurPrenom.Text
Cellule(1, 3) = CorpsDeclarations.DateJour & " / " & CorpsDeclarations.DateMois & " / " & CorpsDeclarations.DateAnnee
Cellule(1, 5) = CorpsDeclarations.Supplement.Text
Cellule(1, 4) = selectioncase
Cellule(1, 6) = CorpsDeclarations.HeureArret_H & " H " & CorpsDeclarations.HeureArret_M.Text
Cellule(1, 7) = CorpsDeclarations.HeureReprise_H & " H " & CorpsDeclarations.HeureReprise_M.Text
Cellule(1, 8) = CorpsDeclarations.TotalHeure_H & " H " & CorpsDeclarations.TotalHeure_M.Text
Cellule(1, 9) = CorpsDeclarations.RaisonPanne.Text
Cellule(1, 10) = CorpsDeclarations.ReparationsReglages.Text
Load CorpsOutlook
CorpsOutlook.Show
End Sub |