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 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
| '---------------------Gérer les boutons de navigation----------------------------------------------------------------------------------------
'
Private Sub cmdPrec_Click()
Dim Position As String
If Position = Range("A2") Then
MsgBox "Vous êtes arrivés au début de la liste"
TextBox1.Value = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox2 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox3 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox5 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox7 = ActiveCell.Value
ActiveCell.Offset(0, 10).Select
TextBox4 = ActiveCell.Value
ActiveCell.Offset(0, 2).Select
TextBox6 = ActiveCell.Value
ActiveCell.Offset(0, 2).Select
TextBox8 = ActiveCell.Value
Else
ActiveCell.Offset(1, 0).Select
TextBox1.Value = ActiveCell.Value
ActiveCell.Offset(0, 0).Select
TextBox2 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox3 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox5 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox7 = ActiveCell.Value
ActiveCell.Offset(0, 10).Select
TextBox4 = ActiveCell.Value
ActiveCell.Offset(0, 2).Select
TextBox6 = ActiveCell.Value
ActiveCell.Offset(0, 2).Select
TextBox8 = ActiveCell.Value
If ActiveCell.Address > Range("A1") Then
MsgBox ActiveCell.Address
ActiveCell.Offset(-1, -17).Select 'Retour en colonne "A", ligne = + 1
End If
End If
End Sub
Private Sub cmdSuiv_Click()
TextBox1.Value = ActiveCell.Value
ActiveCell.Offset(0, 0).Select
TextBox2 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox3 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox5 = ActiveCell.Value
ActiveCell.Offset(0, 1).Select
TextBox7 = ActiveCell.Value
ActiveCell.Offset(0, 10).Select
TextBox4 = ActiveCell.Value
ActiveCell.Offset(0, 2).Select
TextBox6 = ActiveCell.Value
ActiveCell.Offset(0, 2).Select
TextBox8 = ActiveCell.Value
ActiveCell.Offset(1, -17).Select 'Retour en colonne "A", ligne = + 1
End Sub |
Partager