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
|
Sub Enreg_maj()
Fm_clientsP.Cb_cli.ListIndex = (lgn - pl)
Cells(lgn, 3) = Fm_clientsP.Tb_Id
Cells(lgn, 4) = Fm_clientsP.Tb_cip
Cells(lgn, 5) = Fm_clientsP.Tb_civ
Cells(lgn, 6) = Fm_clientsP.Tb_nom
Cells(lgn, 7) = Fm_clientsP.Tb_pre
Cells(lgn, 9) = Fm_clientsP.Tb_post
Cells(lgn, 10) = Fm_clientsP.Tb_TS
Cells(lgn, 11) = Fm_clientsP.Tb_TLD
Cells(lgn, 12) = Fm_clientsP.Tb_mail
Cells(lgn, 14) = Fm_clientsP.Tb_adr
Cells(lgn, 16) = Fm_clientsP.Tb_ville
Cells(lgn, 15) = Fm_clientsP.Tb_CP
Cells(lgn, 18) = Fm_clientsP.Tb_AO
Cells(lgn, 19) = Fm_clientsP.Tb_CA
Cells(lgn, 20) = Fm_clientsP.Tb_eff
Cells(lgn, 21) = Fm_clientsP.Tb_web
Cells(lgn, 13) = Fm_clientsP.Tb_com
Cells(lgn, 22) = Fm_clientsP.Tb_nat1
Cells(lgn, 23) = Fm_clientsP.Tb_plan1
Cells(lgn, 24) = Fm_clientsP.Tb_rea1
Cells(lgn, 25) = Fm_clientsP.Tb_com1
Cells(lgn, 26) = Fm_clientsP.Tb_nat2
Cells(lgn, 27) = Fm_clientsP.Tb_plan2
Cells(lgn, 28) = Fm_clientsP.Tb_rea2
Cells(lgn, 29) = Fm_clientsP.Tb_com2
Cells(lgn, 30) = Fm_clientsP.Tb_statut
End Sub |
Partager