Private Sub UserForm_Activate() Dim plage As Range, c as range Set plage = Range("A1:A" & Range("B" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeConstants) For Each c In plage ListBox1.AddItem c.value Next End Sub
Private Sub UserForm_Activate() Dim plage As Range, c As Range ListBox1.ColumnCount = 2 Set plage = Range("A1:A" & Range("B" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeConstants) For Each c In plage ListBox1.AddItem c.Value ListBox1.List(ListBox1.ListCount - 1, 1) = c.Row Next End Sub
"..je croyais en plus que nous étions un lundi"
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub UserForm_Activate() Dim plage As Range, c As Range Dim cValeur As String ListBox1.ColumnCount = 3 Set plage = Range("A1:A" & Range("B" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeConstants) 'Première valeur cValeur=c.Cells(1,1) For Each c In plage i=i+1 If c.Cells(i,2)="" Then 'ajouter les valeurs au combo cValeur=c.Cells(i,1) Combo1.AddItem cValeur Else 'ajouter la valeurs, les sousvaleurs et les resultats à la listbox. ListBox1.List(ListBox1.ListCount - 1, 1)= cValeur ListBox1.List(ListBox1.ListCount - 1, 2)=c.Cells(i,2) ListBox1.List(ListBox1.ListCount - 1, 3)=c.Cells(i,3) End If Next End Sub
Private Sub UserForm_Activate() With ComboBox1 .ColumnCount = 3 .RowSource = "A1:C" & Range("B" & Rows.Count).End(xlUp).Row End With End Sub