Private Sub Ajouter_Click()
Dim i As Long, k As Byte, Derlig As Long
With Me.ListView1
.ListItems.Clear
With .ColumnHeaders
.Clear
.Add , , "Pièce", 70
.Add , , "Articles", 120
.Add , , "Référence", 90
.Add , , "Qtté", 39
.Add , , "Prix Unitaire", 80
.Add , , "Montant HT", 80
.Add , , "Marge", 40
.Add , , "Pièce", 0
End With
Derlig = Sheets("Devis").Range("A65536").End(xlUp).Row
For i = 20 To Derlig
.ListItems.Add , , Sheets("Devis").Cells(i, 1)
For k = 2 To 8
.ListItems(.ListItems.Count).ListSubItems.Add , , Sheets("Devis").Cells(i, k)
Next
Next
For i = 1 To Derlig - 19
montant = montant + CDbl(.ListItems(i).ListSubItems(5))
Next i
SommeCalculée = montant
End With
End Sub