Option Explicit
Private Sub Enregistrer_Click()
Dim numLigneVide As Integer
Worksheets("Liste").Activate
numLigneVide = ActiveSheet.Columns(1).Find("").Row
If TextBox1.Text = "" Then
MsgBox "Vueillez saisir les données !"
TextBox1.SetFocus
Else
ActiveSheet.Cells(numLigneVide, 1) = TextBox1.Text
ActiveSheet.Cells(numLigneVide, 2) = TextBox2.Text
ActiveSheet.Cells(numLigneVide, 3) = TextBox3.Text
ActiveSheet.Cells(numLigneVide, 4) = TextBox4.Text
ActiveSheet.Cells(numLigneVide, 5) = TextBox5.Text
TextBox1.Text= ""
TextBox2.Text = ""
TextBox3.Text = ""
TextBox4.Text = ""
TextBox5.Text = ""
TextBox1.SetFocus
End If
End Sub