With .LstV_BD
'.Width = 1421
.ListItems.Clear
For L = 2 To UBound(Tab_Annee_Devis, 1)
Date_Compare = Tab_Annee_Devis(L, 1)
If Date_Compare >= FirstDatePeriode And Date_Compare <= LastDatePeriode Then
ReDim Preserve Tab_Resultat(30, X)
Tab_Resultat(1, X) = Tab_Annee_Devis(L, 1)
Set LstVItem = .ListItems.Add(, , Format(Tab_Annee_Devis(L, 1), "dd/mm/yyyy")) ' 0 Date de Debut
With LstVItem 'Avec la Ligne ainsi créée
.ListSubItems.Add , , Tab_Annee_Devis(L, 2) ' 1 Client
.ListSubItems.Add , , Tab_Annee_Devis(L, 3) ' 2 N° facture
.ListSubItems.Add , , Tab_Annee_Devis(L, 4) ' 3 Prestation
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 5), "0.00") ' 4 Facturation HT
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 6), "0.00") ' 5 Facturation TTC
'*************************
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 7), "0.00") ' 6 "Vente marchandise"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 8), "0.00") ' 7 Cotisations "Vente marchandise"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 9), "0.00") ' 8 Impots "Vente marchandise"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 10), "0") ' 9 Taux TVA "Vente marchandise"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 11), "0.00") ' 10 Montant TVA "Vente marchandise"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 12), "0.00") ' 11 Montant TTC "Vente marchandise"
'*************************
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 13), "0.00") ' 12 "Prestation de service Commercial"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 14), "0.00") ' 13 Cotisations "Prestation de service Commercial"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 15), "0.00") ' 14 Impots "Prestation de service Commercial"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 16), "0") ' 15 Taux TVA "Prestation de service Commercial"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 17), "0.00") ' 16 Montant TVA "Prestation de service Commercial"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 18), "0.00") ' 17 Montant TTC "Prestation de service Commercial"
'*************************
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 19), "0.00") ' 18 "Autres Prestations de Services"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 20), "0.00") ' 19 Cotisations "Autres Prestations de Services"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 21), "0.00") ' 20 Impots "Autres Prestations de Services"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 22), "0") ' 21 Taux TVA "Autres Prestations de Services"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 23), "0.00") ' 22 Montant TVA "Autres Prestations de Services"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 24), "0.00") ' 23 Montant TTC "Autres Prestations de Services"
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 25), "0.00") ' 24 Micro Social CFP commerciales
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 26), "0.00") ' 25 Taxes CCI Ventes
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 27), "0.00") ' 26 Taxes CCI Services
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 28), "0.00") ' 27 Payer
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 29), "0.00") ' 28 Total TVA
.ListSubItems.Add , , Format(Tab_Annee_Devis(L, 30), "0.00") ' 29 Bénéfice
.ListSubItems.Add , , 7 + L ' 30 Ligne source
End With