jojoye
Messages postés
4
Date d'inscription
vendredi 21 juillet 2006
Statut
Membre
Dernière intervention
13 novembre 2006
13 nov. 2006 à 18:15
Salut
et merci de t'interesser a mon probleme, voici le code que j'utilise pour alimenter ma ListView.
Private Sub UserForm_Activate()
Worksheets("Articles").Activate
Columns("A:I").Select
Selection.Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Me.TxtRemise = 0
ListView1.ColumnHeaders.Clear
ListView1.ColumnHeaders.Add , , "N° Auto", ListView1.Width * 0, lvwColumnLeft
ListView1.ColumnHeaders.Add , , "Référence", ListView1.Width * 0.15, lvwColumnLeft
ListView1.ColumnHeaders.Add , , "Désignation", ListView1.Width * 0.5, lvwColumnLeft
ListView1.ColumnHeaders.Add , , "Unité", ListView1.Width * 0.05, lvwColumnLeft
ListView1.ColumnHeaders.Add , , "Prix U. HT", ListView1.Width * 0.2, lvwColumnRight
ListView1.ColumnHeaders.Add , , "Prix mini HT", ListView1.Width * 0, lvwColumnRight
Dim iLigArticle As Integer
iLigArticle = 2
ListView1.ListItems.Clear
While Sheets("Articles").Cells(iLigArticle, 1) <> ""
'Alimentation des éléments de la liste
ListView1.ListItems.Add iLigArticle - 1, , Sheets("Articles").Cells(iLigArticle, 1)
ListView1.ListItems(iLigArticle - 1).SubItems(1) = Sheets("Articles").Cells(iLigArticle, 2)
ListView1.ListItems(iLigArticle - 1).SubItems(2) = Sheets("Articles").Cells(iLigArticle, 3)
ListView1.ListItems(iLigArticle - 1).SubItems(3) = Sheets("Articles").Cells(iLigArticle, 4)
ListView1.ListItems(iLigArticle - 1).SubItems(4) = Format(Sheets("Articles").Cells(iLigArticle, 9), "## ##0.00 ?")
ListView1.ListItems(iLigArticle - 1).SubItems(5) = Format(Sheets("Articles").Cells(iLigArticle, 8), "## ##0.00 ?")
iLigArticle = iLigArticle + 1
Wend
End Sub