Bonjour,
Salim, tu peux aussi ajouter le Time....... dans ton For Each:
Private Sub UserForm_Initialize()
Dim Heure As Byte, Minute As Byte, ctrl As Control
For Heure = 6 To 22
For Minute = 0 To 50 Step 30
For Each ctrl In Me.Controls
If TypeOf ctrl Is MSForms.ComboBox Then
ctrl.AddItem Format(Heure, "00") & ":" & Format(Minute, "00")
ctrl.value = ("00:00")
End If
Next ctrl
Next Minute
Next Heure
End Sub
Moi j'ai plutôt crée une array avec les contrôles, exemple du code:
Private Sub UserForm_Initialize()
Dim ComboArray(6) As Control
Dim Heure As Byte, Minute As Byte, i As Byte
Set ComboArray(1) = Time1
Set ComboArray(2) = Time2
Set ComboArray(3) = Time3
Set ComboArray(4) = Time4
Set ComboArray(5) = Time5
Set ComboArray(6) = Time6
For Heure = 6 To 22
For Minute = 0 To 50 Step 30
For i = 1 To 6
With ComboArray(i)
.AddItem Format(Heure, "00") & ":" & Format(Minute, "00")
.Value = ("00:00")
End With
Next i
Next Minute
Next Heure
End Sub
Bonne journée
@Christophe@