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
| Private Sub CmdAnnuler_Click()
End
End Sub
Private Sub CmdValider_Click()
ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 9) = Me.TextBox17
ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 4) = Me.TextBox7
ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 8) = Me.TextBox8
ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 5) = Me.TextBox11
ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 17) = Me.TextBox10
Me.TextBox9 = ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 13) = Me.TextBox9
ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 16) = ""
If Me.CheckBox1.Value = True Then ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 16) = "Chauffeurs"
ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 15) = Me.TextBox14
ActiveWorkbook.Worksheets("Feuil1").Cells(Me.Tag, 7) = Me.TextBox16
End
End Sub
Private Sub ListBox1_Noms_Change()
RenseignerChamps
End Sub
Private Sub UserForm_Initialize()
Me.ListBox1_Noms.ListIndex = 0
End Sub
Sub RenseignerChamps()
Dim MyRange As Range
Dim L As Long
Set MyRange = ActiveWorkbook.Worksheets("Feuil1").Range("A:A")
L = MyRange.Find(Me.ListBox1_Noms).Row
Me.Tag = L
Me.TextBox17 = ActiveWorkbook.Worksheets("Feuil1").Cells(L, 9)
Me.TextBox7 = ActiveWorkbook.Worksheets("Feuil1").Cells(L, 4)
Me.TextBox8 = ActiveWorkbook.Worksheets("Feuil1").Cells(L, 8)
Me.TextBox11 = ActiveWorkbook.Worksheets("Feuil1").Cells(L, 5)
Me.TextBox10 = ActiveWorkbook.Worksheets("Feuil1").Cells(L, 17)
Me.TextBox9 = ActiveWorkbook.Worksheets("Feuil1").Cells(L, 13)
If ActiveWorkbook.Worksheets("Feuil1").Cells(L, 16) = "Chauffeurs" Then Me.CheckBox1.Value = True
Me.TextBox14 = ActiveWorkbook.Worksheets("Feuil1").Cells(L, 15)
Me.TextBox16 = ActiveWorkbook.Worksheets("Feuil1").Cells(L, 7)
End Sub |
Partager