Private Sub CommandButton1_Click()
Dim L As Integer
Dim Fich As String
L = Sheets('Feuil1').Range('A65536').End(xlUp).Row + 1
If TextBox1.Value = '' Then
MsgBox 'Il vous faut saisir une valeur'
TextBox1.SetFocus
Else
With Sheets('Feuil1')
.Range('A' & L).Value = TextBox1.Value
End With
Fich = 'C:\\1\\Dern_Val_TextBox' 'Chemin à adapter
ActiveWorkbook.SaveAs Fich
TextBox1.Value = ''
End If
End Sub
Private Sub CommandButton2_Click()
Unload UserForm1
End Sub
Private Sub UserForm_Initialize()
With UserForm1
.Caption = 'Bonjour' & ' ' & Application.UserName
End With
End Sub