Private Sub CommandButton1_Click()
Dim CTRl As Control
For Each CTRl In Controls
If TypeName(CTRl) = "CheckBox" Then
CTRl = False
End If
Next
End Sub
Sub Decocher_CHBX()
Dim sh As Shape
Application.ScreenUpdating = False
For Each sh In ActiveSheet.Shapes
If sh.Type = 12 Then
If TypeName(sh.OLEFormat.Object.Object) = "CheckBox" Then sh.OLEFormat.Object.Object = False
End If
If sh.Type = 8 Then
If sh.FormControlType = xlCheckBox Then sh.OLEFormat.Object = False
End If
Next sh
Application.ScreenUpdating = True
End Sub
Private Sub CommandButton1_Click()
With Application
[B2] = .Rept("Oui", CheckBox1): [D8] = .Rept("Oui", CheckBox2): [C19] = .Rept("Oui", CheckBox3)
End With
End Sub
Private Sub CommandButton1_Click()
For n = 1 To 15 'ça commence à bien faire
Range(Me("Checkbox" & n).Tag) = Application.Rept("oui", Me("Checkbox" & n))
Next
End Sub
Range(Me("Checkbox" & n).Tag) = IIf(Me("Checkbox" & n), "oui", "")