Voici une partie du code inserer avec le formulaire comprenend la cases a cocher et les boutons " valider" et "annuler"
Private Sub CheckBox7_Click()
If CheckBox7.Value = True Then
[J3] = "Oui"
Else
[J3] = "Non"
End If
End Sub
Private Sub ComboBox2_Change()
End Sub
Private Sub CommandButton1_Click()
UserForm1.Hide
End Sub
Private Sub CommandButton2_Click()
UserForm1.Hide
Worksheets("Feuil1").Rows(3).Select
Selection.Delete
End Sub
Voici la commande pour ouvrir le formulaire dans excel
Worksheets("feuil1").Rows(3).Select
Selection.Insert
With UserForm1
.ComboBox1.Text = ""
.ComboBox2.Text = ""
.TextBox1.Text = ""
.TextBox2.Text = ""
.CheckBox1.Value = False
.CheckBox2.Value = False
.CheckBox3.Value = False
.CheckBox4.Value = False
.CheckBox5.Value = False
.CheckBox6.Value = False
.CheckBox7.Value = False
End With
UserForm1.Show
End Sub
Merci si tu peux faire quelque chose!!