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
| Private Sub ComboBox1_Change()
Sheets("candidats").Select
Range("G10").Select
Do
If ActiveCell <> "" Then ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Value = ""
End Sub
Private Sub ComboBox2_Change()
Sheets("candidats").Select
Range("I10").Select
Do
If ActiveCell <> "" Then ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Value = ""
End Sub
Private Sub ComboBox3_Change()
Sheets("candidats").Select
Range("K10").Select
Do
If ActiveCell <> "" Then ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Value = ""
End Sub
Private Sub CommandButton1_Click()
End Sub
Private Sub TextBox1_Change()
Sheets("candidats").Select
Range("E10").Select
Do
If ActiveCell <> "" Then ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Value = ""
End Sub
Private Sub TextBox2_Change()
Sheets("candidats").Select
Range("F10").Select
Do
If ActiveCell <> "" Then ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Value = ""
End Sub
Private Sub TextBox3_Change()
End Sub
Private Sub UserForm_initialize()
TextBox3 = Range("D10").End(xlDown) + 1
ComboBox1.ColumnCount = 1
ComboBox1.List() = Array("", "Amateur", "Pro")
ComboBox2.ColumnCount = 1
ComboBox2.List() = Array("", "Oui", "Non")
ComboBox3.ColumnCount = 1
ComboBox3.List() = Array("", "Oui", "Non")
End Sub
Private Sub Annuler_Click()
Unload Candidat
End Sub |