Public LastLigne As Long
Public LastColonne As Long
Private Sub CommandButton1_Click()
Dim i As Long, j As Long, l As Long
LastLigne = 46
LastColonne = 16
For i = 1 To 7
If Not Me.Controls("CheckBox" & i).Value Then
' Range(Cells(2, 7 + i), Cells(23, 7 + i)).ClearContents
Cells(25, 7 + i).Font.ColorIndex = xlAutomatic
Cells(25, 7 + i).Interior.ColorIndex = 1
Else
Cells(25, 7 + i).Font.ColorIndex = 2
End If
Next
'Range("A1").Select
'Range("E1").Select
'VIDER LES CHECKBOX
Dim c As Control
For Each c In Me.Controls
Select Case TypeName(c)
Case "CheckBox"
c.Value = False
End Select
Next c
'fermer l'userform
Machine2.Hide
'mise à jour de la couleur de police selon la colonne D
For l = 26 To LastLigne
CouleurPolice = Range("D" & l).Font.ColorIndex
Range("E" & l).Resize(1, LastColonne - 4).Interior.ColorIndex = CouleurPolice
Next l
'mise à jour de la couleur de cellule (gris) selon le contenu de la ligne 2
For j = 5 To LastColonne
If Cells(25, j).Font.ColorIndex = xlAutomatic Then
Cells(26, j).Resize(LastLigne - 25, 1).Interior.ColorIndex = 16 'gris
End If
'mise à jour en rouge des cellules vides et police "blanc" en ligne 2
Next j
'mise à jour en rouge des cellules vides
Range("E26:P46").SpecialCells(xlCellTypeBlanks).Interior.ColorIndex = 3
Calculate
End Sub