Private Sub CBnValiderF_Click()
TVLF(1, 3) = Me.CBxGroupe.Text
TVLF(1, 4) = Me.TBxNomjf.Text
TVLF(1, 5) = Me.TBxPrénom.Text
TVLF(1, 6) = ValeurTBx(Me.TBxDatenaiss, vbDate)
TVLF(1, 7) = Me.TBxLieunaiss.Text
TVLF(1, 8) = Me.TBxDeptnaiss.Text
TVLF(1, 9) = Me.CBxSitufam.Text
TVLF(1, 10) = Me.CBxContrat.Text
TVLF(1, 11) = CDate("1/" & Me.TBxDatecontrat.Text) 'ValeurTBx(Me.TBxDatecontrat, vbDate)
TVLF(1, 12) = Me.TBxEnfants.Text
TVLF(1, 13) = Me.TBxAdract.Text
TVLF(1, 14) = Me.TBxCP.Text
TVLF(1, 15) = Me.TBxVille.Text 'TVLF(1, 15) = ValeurTBx(Me.TBxCréele, vbDate)
TVLF(1, 16) = Me.CBxRP.Text
TVLF(1, 17) = ValeurTBx(Me.TBxLoyer, vbCurrency)
TVLF(1, 18) = CDate("1/" & Me.TBxLoyerdepuis.Text)
TVLF(1, 19) = Me.TBxTel.Text
TVLF(1, 20) = Me.TBxEmail.Text
TVLF(1, 21) = Me.TBxProfession.Text
TVLF(1, 22) = Me.TBxEmployeur.Text
TVLF(1, 23) = Me.CBxTypecont.Text
TVLF(1, 24) = Me.CBxStatut.Text
TVLF(1, 25) = CDate("1/" & Me.TBxAnciennete.Text)
TVLF(1, 26) = Me.TBxPays.Text
TVLF(1, 27) = Me.TBxNationalite.Text
TVLF(1, 28) = Me.CBxIBBanque.Text
TVLF(1, 29) = Me.TBxIBAgen.Text
TVLF(1, 30) = Me.TBxIBAdr.Text
TVLF(1, 31) = Me.TBxIBCP.Text
TVLF(1, 32) = Me.TBxIBVille.Text
TVLF(1, 33) = Me.TBxIBNom.Text
TVLF(1, 34) = ValeurTBx(Me.TBxRSalaire, vbCurrency) 'CCur("1/" & Me.TBxRSalaire.Text)
TVLF(1, 35) = ValeurTBx(Me.TBxRAlloc, vbCurrency)
TVLF(1, 36) = ValeurTBx(Me.TBxRRFoncier, vbCurrency)
TVLF(1, 37) = ValeurTBx(Me.TBxRPensions, vbCurrency)
TVLF(1, 38) = ValeurTBx(Me.TBxRRFRN1, vbCurrency)
TVLF(1, 39) = ValeurTBx(Me.TBxRRFRN2, vbCurrency)
TVLF(1, 40) = ValeurTBx(Me.TBxRIRPP, vbCurrency)
TVLF(1, 41) = Me.CBxNom2.Text
TVLF(1, 42) = Me.TBxNomjf2.Text
TVLF(1, 43) = Me.TBxPrénom2.Text
TVLF(1, 44) = Me.TBxDatenaiss2.Text
TVLF(1, 45) = Me.TBxLieunaiss2.Text
TVLF(1, 46) = Me.TBxDeptnaiss2.Text
TVLF(1, 47) = Me.CBxSitufam2.Text
TVLF(1, 48) = Me.CBxContrat2.Text
TVLF(1, 49) = CDate("1/" & Me.TBxDatecontrat2.Text)
TVLF(1, 50) = Me.TBxEnfants2.Text
TVLF(1, 51) = Me.TBxAdract2.Text
TVLF(1, 52) = Me.TBxCP2.Text
TVLF(1, 53) = Me.TBxVille2.Text
TVLF(1, 54) = Me.CBxRP2.Text
TVLF(1, 55) = Me.TBxLoyer2.Text
TVLF(1, 56) = CDate("1/" & Me.TBxLoyerdepuis2.Text)
TVLF(1, 57) = Me.TBxTel2.Text
TVLF(1, 58) = Me.TBxEmail2.Text
TVLF(1, 59) = Me.TBxProfession2.Text
TVLF(1, 60) = Me.TBxEmployeur2.Text
TVLF(1, 61) = Me.CBxTypecont2.Text
TVLF(1, 62) = Me.CBxStatut2.Text
TVLF(1, 63) = CDate("1/" & Me.TBxAnciennete2.Text)
TVLF(1, 64) = Me.TBxPays2.Text
TVLF(1, 65) = Me.TBxNationalite2.Text
TVLF(1, 66) = Me.CBxIBBanque2.Text
TVLF(1, 67) = Me.TBxIBAgen2.Text
TVLF(1, 68) = Me.TBxIBAdr2.Text
TVLF(1, 69) = Me.TBxIBCP2.Text
TVLF(1, 70) = Me.TBxIBVille2.Text
TVLF(1, 71) = Me.TBxIBNom2.Text
TVLF(1, 72) = ValeurTBx(Me.TBxRSalaire2, vbCurrency) 'CCur("1/" & Me.TBxRSalaire.Text)
TVLF(1, 73) = ValeurTBx(Me.TBxRAlloc2, vbCurrency)
TVLF(1, 74) = ValeurTBx(Me.TBxRRFoncier2, vbCurrency)
TVLF(1, 75) = ValeurTBx(Me.TBxRPensions2, vbCurrency)
TVLF(1, 76) = ValeurTBx(Me.TBxRRFRN12, vbCurrency)
TVLF(1, 77) = ValeurTBx(Me.TBxRRFRN22, vbCurrency)
TVLF(1, 78) = ValeurTBx(Me.TBxRIRPP2, vbCurrency)
TVLF(1, 79) = Me.TBxCNom1.Text
TVLF(1, 80) = Me.CBxCNat1.Text
TVLF(1, 81) = CDate("1/" & Me.TBxCDatreal1.Text)
TVLF(1, 82) = CDate("1/" & Me.TBxCDatfin1.Text)
TVLF(1, 83) = ValeurTBx(Me.TBxCRest1, vbCurrency)
TVLF(1, 84) = Me.TBxCNom2.Text
TVLF(1, 85) = Me.CBxCNat2.Text
TVLF(1, 86) = CDate("1/" & Me.TBxCDatreal2.Text)
TVLF(1, 87) = CDate("1/" & Me.TBxCDatfin2.Text)
TVLF(1, 88) = ValeurTBx(Me.TBxCRest2, vbCurrency)
TVLF(1, 89) = Me.TBxCNom3.Text
TVLF(1, 90) = Me.CBxCNat3.Text
TVLF(1, 91) = CDate("1/" & Me.TBxCDatreal3.Text)
TVLF(1, 92) = CDate("1/" & Me.TBxCDatfin3.Text)
TVLF(1, 93) = ValeurTBx(Me.TBxCRest3, vbCurrency)
TVLF(1, 94) = Me.TBxCNom4.Text
TVLF(1, 95) = Me.CBxCNat4.Text
TVLF(1, 96) = CDate("1/" & Me.TBxCDatreal4.Text)
TVLF(1, 97) = CDate("1/" & Me.TBxCDatfin4.Text)
TVLF(1, 98) = ValeurTBx(Me.TBxCRest4, vbCurrency)
TVLF(1, 99) = Me.TBxCNom5.Text
TVLF(1, 100) = Me.CBxCNat5.Text
TVLF(1, 101) = CDate("1/" & Me.TBxCDatreal5.Text)
TVLF(1, 102) = CDate("1/" & Me.TBxCDatfin5.Text)
TVLF(1, 103) = ValeurTBx(Me.TBxCRest5, vbCurrency)
TVLF(1, 104) = ValeurTBx(Me.TBxCPens, vbCurrency)
TVLF(1, 105) = Me.CBxIProp1.Text
TVLF(1, 106) = Me.TBxIDes1.Text
TVLF(1, 107) = ValeurTBx(Me.TBxIVal1, vbCurrency)
TVLF(1, 108) = Me.TBxIAdr1.Text
TVLF(1, 109) = ValeurTBx(Me.TBxILoy1, vbCurrency)
TVLF(1, 110) = Me.CBxIProp2.Text
TVLF(1, 111) = Me.TBxIDes2.Text
TVLF(1, 112) = ValeurTBx(Me.TBxIVal2, vbCurrency)
TVLF(1, 113) = Me.TBxIAdr2.Text
TVLF(1, 114) = ValeurTBx(Me.TBxILoy2, vbCurrency)
TVLF(1, 115) = Me.CBxIProp3.Text
TVLF(1, 116) = Me.TBxIDes3.Text
TVLF(1, 117) = ValeurTBx(Me.TBxIVal3, vbCurrency)
TVLF(1, 118) = Me.TBxIAdr3.Text
TVLF(1, 119) = ValeurTBx(Me.TBxILoy3, vbCurrency)
TVLF(1, 120) = Me.CBxIProp4.Text
TVLF(1, 121) = Me.TBxIDes4.Text
TVLF(1, 122) = ValeurTBx(Me.TBxIVal4, vbCurrency)
TVLF(1, 123) = Me.TBxIAdr4.Text
TVLF(1, 124) = ValeurTBx(Me.TBxILoy4, vbCurrency)
TVLF(1, 125) = Me.CBxIProp5.Text
TVLF(1, 126) = Me.TBxIDes5.Text
TVLF(1, 127) = ValeurTBx(Me.TBxIVal5, vbCurrency)
TVLF(1, 128) = Me.TBxIAdr5.Text
TVLF(1, 129) = ValeurTBx(Me.TBxILoy5, vbCurrency)
TVLF(1, 130) = Me.CBxPATit1.Text
TVLF(1, 131) = Me.CBxPADes1.Text
TVLF(1, 132) = Me.TBxPAOrg1.Text
TVLF(1, 133) = ValeurTBx(Me.TBxPAMon1, vbCurrency)
TVLF(1, 134) = ValeurTBx(Me.TBxPADat1, vbDate)
TVLF(1, 135) = ValeurTBx(Me.TBxPAEpm1, vbCurrency)
TVLF(1, 136) = Me.CBxPATit2.Text
TVLF(1, 137) = Me.CBxPADes2.Text
TVLF(1, 138) = Me.TBxPAOrg2.Text
TVLF(1, 139) = ValeurTBx(Me.TBxPAMon2, vbCurrency)
TVLF(1, 140) = ValeurTBx(Me.TBxPADat2, vbDate)
TVLF(1, 141) = ValeurTBx(Me.TBxPAEpm2, vbCurrency)
TVLF(1, 142) = Me.CBxPATit3.Text
TVLF(1, 143) = Me.CBxPADes3.Text
TVLF(1, 144) = Me.TBxPAOrg3.Text
TVLF(1, 145) = ValeurTBx(Me.TBxPAMon3, vbCurrency)
TVLF(1, 146) = ValeurTBx(Me.TBxPADat3, vbDate)
TVLF(1, 147) = ValeurTBx(Me.TBxPAEpm3, vbCurrency)
TVLF(1, 148) = Me.CBxPATit4.Text
TVLF(1, 149) = Me.CBxPADes4.Text
TVLF(1, 150) = Me.TBxPAOrg4.Text
TVLF(1, 151) = ValeurTBx(Me.TBxPAMon4, vbCurrency)
TVLF(1, 152) = ValeurTBx(Me.TBxPADat4, vbDate)
TVLF(1, 153) = ValeurTBx(Me.TBxPAEpm4, vbCurrency)
If LCouF = 0 Then
CLsF.ValeursVers TVLF
CLsF.Lignes.Add.Range.Value = TVLF ' . value2 => ancienne version d'excel ne changeant par le format
CLsF.Actualiser
Me.LabNbfournisseur = CLsF.Lignes.Count 'comptage nombre de fournisseur
Set DicF = DicoSujet(CLsF.Item(CBxNom).SujetBdD)
Else
CLsF.Lignes(LCouF).Range.Value = TVLF
End If
Unload Me
FRmGlobal.Show
End Sub