Private Sub CmbValider_Click()
Dim MonCommentaire As String, I As Integer
With Sheets("Buanderie")
If -CheckBox1 - CheckBox2 - CheckBox3 - CheckBox4 >= 2 Then
.cells(7, 1) = "Oui"
Else
.cells(7, 1) = "Non"
End If
For I = 1 To 4
If Controls("CheckBox" & I) = -1 Then
MonCommentaire = MonCommentaire & Controls("CheckBox" & I).Caption & Chr(10)
End If
Next I
.cells(7, 1).Comment.text text:=MonCommentaire
End With
Unload Me
End Sub