Private Sub UserForm_Initialize()
k = 0
With Sheets("Base") 'MA FEULLE QUI CONTIENT LA BASE DE DONNEES
For i = 2 To .[A65000].End(xlUp).Row
If Not IsEmpty(.Cells(i, 105)) And Not IsEmpty(.Cells(i, 106)) Then
Me.ListBox1.AddItem
Me.ListBox1.List(k, 0) = .Cells(i, 1) 'COLONNE NUM DOSSIER
Me.ListBox1.List(k, 1) = .Cells(i, 3) 'COLONNE NOM
Me.ListBox1.List(k, 2) = .Cells(i, 4) 'COLONNE PRENOM
Me.ListBox1.List(k, 3) = .Cells(i, 10) 'COLONNE MARQUE
Me.ListBox1.List(k, 4) = .Cells(i, 11) 'COLONNE MODELE
Me.ListBox1.List(k, 5) = .Cells(i, 105) 'COLONNE ACTIONS
Me.ListBox1.List(k, 6) = .Cells(i, 106) 'COLONNE RELANCE'
k = k + 1
End If
Next i
End With
End Sub
Private Sub CommandButton1_Click()
Unload Me
End Sub