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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
| Private Sub CommandButton3_Click() ' retour accueil
'UserForm3.Hide
Unload Me
End Sub
Private Sub UserForm_Initialize()
'For i = 1 To 31
'Me.Controls("TextBox" & i).Value = "0.00"
'Next i
CalculUsf3
End Sub
Sub CalculUsf3()
With Sheets("Comptabilité")
'TextBox4.Value = "0,00"
' fait la somme de la colonne Recette/dépense en fonction du contenu de la colonne L Catégorie
TextBox3.Value = Application.SumIf(.Columns("L"), "706200", .Columns("B")) + Application.SumIf(.Columns("L"), "706200", .Columns("D")) + Application.SumIf(.Columns("L"), "706200", .Columns("F"))
TextBox4.Value = Application.SumIf(.Columns("L"), "708800", .Columns("B")) + Application.SumIf(.Columns("L"), "708800", .Columns("D")) + Application.SumIf(.Columns("L"), "708800", .Columns("F"))
TextBox5.Value = Application.SumIf(.Columns("L"), "740000", .Columns("B")) + Application.SumIf(.Columns("L"), "740000", .Columns("D")) + Application.SumIf(.Columns("L"), "740000", .Columns("F"))
TextBox6.Value = Application.SumIf(.Columns("L"), "747000", .Columns("B")) + Application.SumIf(.Columns("L"), "747000", .Columns("D")) + Application.SumIf(.Columns("L"), "747000", .Columns("F"))
TextBox7.Value = Application.SumIf(.Columns("L"), "754110", .Columns("B")) + Application.SumIf(.Columns("L"), "754110", .Columns("D")) + Application.SumIf(.Columns("L"), "754110", .Columns("F"))
TextBox8.Value = Application.SumIf(.Columns("L"), "756000", .Columns("B")) + Application.SumIf(.Columns("L"), "756000", .Columns("D")) + Application.SumIf(.Columns("L"), "756000", .Columns("F"))
TextBox25.Value = Application.SumIf(.Columns("L"), "512000", .Columns("C")) + Application.SumIf(.Columns("L"), "512000", .Columns("E")) + Application.SumIf(.Columns("L"), "512000", .Columns("G"))
TextBox26.Value = Application.SumIf(.Columns("L"), "602230", .Columns("C")) + Application.SumIf(.Columns("L"), "602230", .Columns("E")) + Application.SumIf(.Columns("L"), "602230", .Columns("G"))
TextBox12.Value = Application.SumIf(.Columns("L"), "602250", .Columns("C")) + Application.SumIf(.Columns("L"), "602250", .Columns("E")) + Application.SumIf(.Columns("L"), "602250", .Columns("G"))
TextBox13.Value = Application.SumIf(.Columns("L"), "605000", .Columns("C")) + Application.SumIf(.Columns("L"), "605000", .Columns("E")) + Application.SumIf(.Columns("L"), "605000", .Columns("G"))
TextBox14.Value = Application.SumIf(.Columns("L"), "606100", .Columns("C")) + Application.SumIf(.Columns("L"), "606100", .Columns("E")) + Application.SumIf(.Columns("L"), "606100", .Columns("G"))
TextBox15.Value = Application.SumIf(.Columns("L"), "606800", .Columns("C")) + Application.SumIf(.Columns("L"), "606800", .Columns("E")) + Application.SumIf(.Columns("L"), "606800", .Columns("G"))
TextBox16.Value = Application.SumIf(.Columns("L"), "607000", .Columns("C")) + Application.SumIf(.Columns("L"), "607000", .Columns("E")) + Application.SumIf(.Columns("L"), "607000", .Columns("G"))
TextBox17.Value = Application.SumIf(.Columns("L"), "613510", .Columns("C")) + Application.SumIf(.Columns("L"), "613510", .Columns("E")) + Application.SumIf(.Columns("L"), "613510", .Columns("G"))
TextBox18.Value = Application.SumIf(.Columns("L"), "615000", .Columns("C")) + Application.SumIf(.Columns("L"), "615000", .Columns("E")) + Application.SumIf(.Columns("L"), "615000", .Columns("G"))
TextBox19.Value = Application.SumIf(.Columns("L"), "615600", .Columns("C")) + Application.SumIf(.Columns("L"), "615600", .Columns("E")) + Application.SumIf(.Columns("L"), "615600", .Columns("G"))
TextBox20.Value = Application.SumIf(.Columns("L"), "616100", .Columns("C")) + Application.SumIf(.Columns("L"), "616100", .Columns("E")) + Application.SumIf(.Columns("L"), "616100", .Columns("G"))
TextBox27.Value = Application.SumIf(.Columns("L"), "622600", .Columns("C")) + Application.SumIf(.Columns("L"), "622600", .Columns("E")) + Application.SumIf(.Columns("L"), "622600", .Columns("G"))
TextBox28.Value = Application.SumIf(.Columns("L"), "623400", .Columns("C")) + Application.SumIf(.Columns("L"), "623400", .Columns("E")) + Application.SumIf(.Columns("L"), "623400", .Columns("G"))
TextBox29.Value = Application.SumIf(.Columns("L"), "625100", .Columns("C")) + Application.SumIf(.Columns("L"), "625100", .Columns("E")) + Application.SumIf(.Columns("L"), "625100", .Columns("G"))
TextBox30.Value = Application.SumIf(.Columns("L"), "625600", .Columns("C")) + Application.SumIf(.Columns("L"), "625600", .Columns("E")) + Application.SumIf(.Columns("L"), "625600", .Columns("G"))
TextBox31.Value = Application.SumIf(.Columns("L"), "626100", .Columns("C")) + Application.SumIf(.Columns("L"), "626100", .Columns("E")) + Application.SumIf(.Columns("L"), "626100", .Columns("G"))
TextBox32.Value = Application.SumIf(.Columns("L"), "626200", .Columns("C")) + Application.SumIf(.Columns("L"), "626200", .Columns("E")) + Application.SumIf(.Columns("L"), "626200", .Columns("G"))
TextBox33.Value = Application.SumIf(.Columns("L"), "627100", .Columns("C")) + Application.SumIf(.Columns("L"), "627100", .Columns("E")) + Application.SumIf(.Columns("L"), "627100", .Columns("G"))
TextBox34.Value = Application.SumIf(.Columns("L"), "631000", .Columns("C")) + Application.SumIf(.Columns("L"), "631000", .Columns("E")) + Application.SumIf(.Columns("L"), "631000", .Columns("G"))
TextBox35.Value = Application.SumIf(.Columns("L"), "635400", .Columns("C")) + Application.SumIf(.Columns("L"), "635400", .Columns("E")) + Application.SumIf(.Columns("L"), "635400", .Columns("G"))
TextBox36.Value = Application.SumIf(.Columns("L"), "641100", .Columns("C")) + Application.SumIf(.Columns("L"), "641100", .Columns("E")) + Application.SumIf(.Columns("L"), "641100", .Columns("G"))
TextBox37.Value = Application.SumIf(.Columns("L"), "658200", .Columns("C")) + Application.SumIf(.Columns("L"), "658200", .Columns("E")) + Application.SumIf(.Columns("L"), "658200", .Columns("G"))
End With
End Sub |
Partager