'procedure pour valider saisie dans base de donnees
Private Sub btnajout_Click()
With Sheets("index")
With .Cells(.Cells(.Rows.Count, 1).End(xlUp).Row + 1, 1)
.Value = DateValue(Textdate.Value)
.Offset(0, 1) = Textjour.Value
.Offset(0, 2).Value = Textnuit.Value
End With
End With
End Sub