1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| Private Sub UserForm_Initialize()
Dim debut_col As Integer, ligne As Integer, fin_col As Integer, i As Integer, entete1 As String, entete2 As String
Dim donnee1 As String, donnee2 As String, NoLig As Integer
debut_col = 2
ligne = debut_col
While Worksheets("Feuil1").Cells(ligne, 1) <> ""
ligne = ligne + 1
Wend
fin_col = ligne - 1
entete1 = Worksheets("Feuil1").Cells(1, 1)
entete2 = Worksheets("Feuil1").Cells(1, 2)
'Les données sont dans la Feuil2.
'La premiere ligne, de la colonne A à J contient les entêtes.
ListView1.ColumnHeaders.Clear
ListView1.ColumnHeaders.Add , , entete1, 70
ListView1.ColumnHeaders.Add 1, , entete2, 70
NoLig = 0
For i = 2 To fin_col 'N° de lignes de ta feuille de calculs
NoLig = NoLig + 1 'N° de lignes de ta listview
ListView1.ListItems(NoLig).Add , , Worksheets("Feuil1").Cells(i, 1)
ListView1.ListItems(NoLig).Add , , Worksheets("Feuil1").Cells(i, 2)
Next
End Sub |
Partager