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
|
Sub variables()
Dim var1 As Integer
Public A, B, C, D, E, F
End Sub
Sub enregistre()
Dim EntreePlus As Worksheet, ZZ As Range, Erg, i As Integer, AA As Range, BB As Range, EE As Range, XX As Range, YY As Range, FF As Range, GG As Range
Set EntreePlus = ThisWorkbook.Worksheets("Feuil1")
Application.ScreenUpdating = True
Set XX = EntreePlus.Cells(16384, 1).End(xlUp).Offset(1, 0) 'civilité
Set ZZ = EntreePlus.Cells(16384, 2).End(xlUp).Offset(1, 0) 'nom
Set YY = EntreePlus.Cells(16384, 3).End(xlUp).Offset(1, 0) 'prénom
Set AA = EntreePlus.Cells(16384, 4).End(xlUp).Offset(1, 0) 'adresse
Set BB = EntreePlus.Cells(16384, 5).End(xlUp).Offset(1, 0) 'code postal
Set EE = EntreePlus.Cells(16384, 6).End(xlUp).Offset(1, 0) 'ville
XX.Offset(0, i).Value = A
ZZ.Offset(0, i).Value = UserForm004.TextBox3.Text
YY.Offset(0, i).Value = C
AA.Offset(0, i).Value = D
BB.Offset(0, i).Value = E
EE.Offset(0, i).Value = F
Application.ScreenUpdating = True
MsgBox "Les données ont été enregistrées avec succés"
End Sub |
Partager