Bonjour
Macro à modifier Private Sub CommandButton3_Click()
Dim c As Control
For Each c In Me.Controls 'remise à zéro USF
Select Case TypeName(c)
Case "TextBox"
c.Value = ""
Case "CheckBox"
c.Value = False
Case "ListBox", "ComboBox"
c.ListIndex = -1
End Select
Next c
End With
InitCBB4
End Sub
Macro à changer Private Sub UserForm_Initialize()
Private Sub UserForm_Initialize()
With Sheets("mouvements") 'prend en compte l'onglet "mouvements"
'alimentation dynamique des comboboxes
ComboBox2.RowSource = "Mouvements!X2:X" & .Cells(Rows.Count, 24).End(xlUp).Row
ComboBox1.RowSource = "Mouvements!Y2:Y" & .Cells(Rows.Count, 25).End(xlUp).Row
ComboBox3.RowSource = "Mouvements!Z2:Z" & .Cells(Rows.Count, 26).End(xlUp).Row
End With 'fin de la prise en compte de l'onglet "mouvements"
InitCBB4
End Sub
Macro à ajouter Sub InitCBB4()
Sub InitCBB4()
Dim J As Long
Me.ComboBox4.Clear
With Sheets("Feuil1")
For J = 1 To .Range("A" & Rows.Count).End(xlUp).Row
If .Range("A" & J) <> 0 Then ComboBox4.AddItem .Range("A" & J)
Next J
End With
End Sub
Pour info : Tu es en mode de calcul manuel