Bonjour Temjeh et le forum,
Essayes avec ce code :
Application.DisplayAlerts = False
ActiveCell = TextBox1
ActiveCell.Offset(0, 1).Value = TextBox2
ActiveCell.Offset(0, 2).Value = TextBox3
ActiveCell.Offset(0, 3).Value = TextBox4
ActiveCell.Offset(0, 5).Value = TextBox5
ActiveCell.Offset(0, 6).Value = TextBox6
ActiveCell.Offset(0, 7).Value = TextBox7
ActiveCell.Offset(0, 4).Value = ComboBox1
Application.DisplayAlerts = True
Cordialement
Bernard