Bonjour
modification combobox a voir
Private Sub UserForm_Initialize()
Dim I&, C&
Application.ScreenUpdating = False
With Sheets("donn?es")
For I = 51 To 59
ComboBox_peloton.AddItem .Cells(I, 3)
Next
For C = 1 To 1169
ComboBox_CodeP.AddItem .Cells(1, C)
Next
End With
End Sub
Private Sub ComboBox_CodeP_Change()
Dim no_colonne As Integer, nb_ligne As Integer
Dim I&
no_colonne = ComboBox_CodeP.ListIndex + 1
ListBox_Villes.Clear
With Sheets("donn?es")
nb_ligne = .Cells(1, no_colonne).End(xlDown).Row
For I = 2 To nb_ligne
ListBox_Villes.AddItem .Cells(I, no_colonne)
Next
End With
End Sub
A+
Maurice