Re Papi27190 le forum
tu peux déjà remplacer le code de UserForm_Initialize par ci-dessous
a+
papou
Private Sub UserForm_Initialize()
Dim i, J, n
Me.Caption = "Statut actuel du Projet " & Chr(169)
With Feuil1
For i = 1 To 13
If .Cells(li, i) <> "" Then Controls("CheckBox" & i) = 1 Else Controls("CheckBox" & i) = 0
Next i
End With
For Each n In Array(1, 3, 5, 7, 9, 11, 14, 16, 18, 20, 22, 24, 26)
For i = 1 To 53
Controls("Combobox" & n).AddItem "S" & "" & i
Next i
Next n
For Each n In Array(2, 4, 6, 8, 10, 12, 15, 17, 19, 21, 23, 25, 27)
For i = 2015 To 2030
Controls("Combobox" & n).AddItem i
Next i
Next n
With ComboBox13
.AddItem "SAB"
.AddItem "CAB"
.AddItem "DAB"
.AddItem "PAB"
.AddItem "KAB"
.AddItem "SB"
.AddItem "BK"
.AddItem "PHL"
End With
End Sub