Private Sub UserForm_Initialize()
With Me.ListView1: .Gridlines = True: .View = 3
With .ColumnHeaders
For i = 1 To ActiveSheet.UsedRange.Columns.Count
.Add , , ActiveSheet.Cells(1, i).Value, 70
Next i
.Add , , "Montant HT"
.Add , , "Montant TVA"
.Add , , "Montant TTC"
End With
For i = 2 To ActiveSheet.UsedRange.Rows.Count + 2
.ListItems.Add , , ActiveSheet.Cells(i, 1).Value
.ListItems(.ListItems.Count).Key = "R " & i
For j = 2 To ActiveSheet.UsedRange.Columns.Count
.ListItems(.ListItems.Count).ListSubItems.Add , , ActiveSheet.Cells(i, j).Value
Next j
montantht = ActiveSheet.Cells(i, 2).Value * ActiveSheet.Cells(i, 5).Value * (1 - ActiveSheet.Cells(i, 4).Value)
tva = ActiveSheet.Cells(i, 2).Value * ActiveSheet.Cells(i, 5).Value * (1 - ActiveSheet.Cells(i, 4).Value) * ActiveSheet.Cells(i, 3).Value
.ListItems(.ListItems.Count).ListSubItems.Add , , montantht
.ListItems(.ListItems.Count).ListSubItems.Add , , tva
.ListItems(.ListItems.Count).ListSubItems.Add , , tva + montantht
totalht = totalht + montantht
totaltva = totaltva + tva
totalttc = totalttc + tva + montantht
Next i
End With
Me.Label1 = "Total HTVA : " & totalht
Me.Label2 = "Total TVAC : " & totalttc
Me.Label3 = "Total tva : " & totaltva
End Sub