un bout du code parce que je n'arrive pas a joindre le fichier
merci d'avance
Private Sub Dat_Change()
Sheets('feuil1').Range('B2').Value = Dat.Value
End Sub
Private Sub Report_Change()
Sheets('feuil1').Range('C18').Value = Report.Value
TotalJ.Value = Val(TotalR.Value) + Val(Report.Value)
End Sub
''''''''''''''''''formule recette''''''''''''''''''''
Private Sub Entree_Change()
Sheets('feuil1').Range('C5').Value = Entree.Value
TotalR.Value = Val(Entree.Value) + Val(Vente.Value) + Val(Vestiaire.Value) + Val(RDisco.Value) + Val(RPub.Value)
End Sub
Private Sub Vente_Change()
Sheets('feuil1').Range('C7').Value = Vente.Value
TotalR.Value = Val(Entree.Value) + Val(Vente.Value) + Val(Vestiaire.Value) + Val(RDisco.Value) + Val(RPub.Value)
End Sub
Private Sub Vestiaire_Change()
Sheets('feuil1').Range('C9').Value = Vestiaire.Value
TotalR.Value = Val(Entree.Value) + Val(Vente.Value) + Val(Vestiaire.Value) + Val(RDisco.Value) + Val(RPub.Value)
End Sub
Private Sub RDisco_Change()
Sheets('feuil1').Range('C11').Value = RDisco.Value
TotalR.Value = Val(Entree.Value) + Val(Vente.Value) + Val(Vestiaire.Value) + Val(RDisco.Value) + Val(RPub.Value)
End Sub
Private Sub RPub_Change()
Sheets('feuil1').Range('C13').Value = RPub.Value
TotalR.Value = Val(Entree.Value) + Val(Vente.Value) + Val(Vestiaire.Value) + Val(RDisco.Value) + Val(RPub.Value)
End Sub
''''''''''''Formule pour les depence''''''''''''''''''''''''''''''''''''''''
Private Sub CbEntree_Change()
Sheets('feuil1').Range('F5').Value = CbEntree.Value
TotalDepence.Value = Val(CbEntree.Value) + Val(CbEntree2.Value) + Val(CbDisco.Value) + Val(CbDisco2.Value) + Val(CbPub.Value) + Val(CbPub2.Value) + Val(Banque.Value) + Val(divers.Value)
End Sub
Private Sub CbEntree2_Change()
Sheets('feuil1').Range('F7').Value = CbEntree2.Value
TotalDepence.Value = Val(CbEntree.Value) + Val(CbEntree2.Value) + Val(CbDisco.Value) + Val(CbDisco2.Value) + Val(CbPub.Value) + Val(CbPub2.Value) + Val(Banque.Value) + Val(divers.Value)
End Sub
Private Sub cbDisco_Change()
Sheets('feuil1').Range('F9').Value = CbDisco.Value
TotalDepence.Value = Val(CbEntree.Value) + Val(CbEntree2.Value) + Val(CbDisco.Value) + Val(CbDisco2.Value) + Val(CbPub.Value) + Val(CbPub2.Value) + Val(Banque.Value) + Val(divers.Value)
End Sub
Private Sub cbDisco2_Change()
Sheets('feuil1').Range('F11').Value = CbDisco2.Value
TotalDepence.Value = Val(CbEntree.Value) + Val(CbEntree2.Value) + Val(CbDisco.Value) + Val(CbDisco2.Value) + Val(CbPub.Value) + Val(CbPub2.Value) + Val(Banque.Value) + Val(divers.Value)
End Sub
Private Sub cbPub_Change()
Sheets('feuil1').Range('F13').Value = CbPub.Value
TotalDepence.Value = Val(CbEntree.Value) + Val(CbEntree2.Value) + Val(CbDisco.Value) + Val(CbDisco2.Value) + Val(CbPub.Value) + Val(CbPub2.Value) + Val(Banque.Value) + Val(divers.Value)
End Sub
Private Sub cbPub2_Change()
Sheets('feuil1').Range('F15').Value = CbPub2.Value
TotalDepence.Value = Val(CbEntree.Value) + Val(CbEntree2.Value) + Val(CbDisco.Value) + Val(CbDisco2.Value) + Val(CbPub.Value) + Val(CbPub2.Value) + Val(Banque.Value) + Val(divers.Value)
End Sub
Private Sub Banque_Change()
Sheets('feuil1').Range('F17').Value = Banque.Value
TotalDepence.Value = Val(CbEntree.Value) + Val(CbEntree2.Value) + Val(CbDisco.Value) + Val(CbDisco2.Value) + Val(CbPub.Value) + Val(CbPub2.Value) + Val(Banque.Value) + Val(divers.Value)
End Sub
Private Sub Divers_Change()
Sheets('feuil1').Range('F19').Value = divers.Value
TotalDepence.Value = Val(CbEntree.Value) + Val(CbEntree2.Value) + Val(CbDisco.Value) + Val(CbDisco2.Value) + Val(CbPub.Value) + Val(CbPub2.Value) + Val(Banque.Value) + Val(divers.Value)
End Sub
''''''''''''''''''''total depence'''''''''''''''''''''''''''''''''''''
Private Sub TotalDepence_Change()
TotalD = TotalDepence.Value
Sheets('feuil1').Range('F22,C22').Value = TotalDepence.Value
End Sub
'''''''''''''''''''''total recette'''''''''''''''''''''''
'Private Sub TotalR_Change()
'Sheets('feuil1').Range('C16').Value = TotalR.Value
'TotalJ.Value = val(TotalR.Value) + val(Report.Value)
'End Sub
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''total recette + report''''''''''''''''''''
'Private Sub TotalJ_Change()
'Sheets('feuil1').Range('C20').Value = TotalR.Value
'TOTAL.Value = val(TotalJ.Value) - val(TotalD.Value)
'End Sub
Private Sub TOTAL_enter()
TOTAL.Value = Val(TotalJ.Value) - Val(TotalD.Value)
Sheets('feuil1').Range('C24').Value = TOTAL.Value
'TOTAL.Value = Format(TOTAL.Value, '#,##0.00 [$F-40C]')
End Sub
Private Sub TotalJ_enter()
Sheets('feuil1').Range('C16').Value = TotalR.Value
TotalJ.Value = Val(TotalR.Value) + Val(Report.Value)
End Sub