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
|
Private Sub Cmb1_Click()
Dim erreur(2) As Boolean, msg As String, I As Byte
Dim Tablo As Variant
Tablo = Array("", "Lieu ?", "Date ?")
erreur(1) = UFsais.T3.Value = ""
erreur(2) = UFsais.T2.Value = ""
For I = 1 To 2
If erreur(I) Then msg = msg & vbCrLf & "-" & " " & Tablo(I)
Next
If msg <> "" Then
MsgBox "Vous avez oublié" & msg, 0, "A vérifier"
Exit Sub
End If
ActiveSheet.Activate
If Range("A6") = "" Then
Range("A6").Select
Else
Range("A5").End(xlDown).Select
ActiveCell.Offset(1, 0).Range("a1").Select
End If
ActiveCell.Value = CDate(T1)
If UFsais.Ch2.Value = True Then
ActiveCell.Offset(0, 1).Value = CDate(UFsais.T3)
ActiveCell.Offset(0, 2).Value = UFsais.T20.Value
ActiveCell.Offset(0, 3).Value = UFsais.T2.Value
End If
If UFsais.Ch1.Value = True Then
ActiveCell.Offset(0, 5).Value = CDate(UFsais.T3)
ActiveCell.Offset(0, 6).Value = UFsais.T2.Value
ActiveCell.Offset(0, 14).Value = UFsais.T4.Value
ActiveCell.Offset(0, 15).Value = UFsais.T19.Value
ActiveCell.Offset(0, 16).Value = UFsais.T5.Value
End If
If UFsais.Ch9.Value = True Then
ActiveCell.Offset(0, 17).Value = "X"
End If
If UFsais.Ch7.Value = True Then
ActiveCell.Offset(0, 8).Value = "X"
End If
If UFsais.Ch8.Value = True Then
ActiveCell.Offset(0, 9).Value = "X"
End If
If UFsais.Ch6.Value = True Then
ActiveCell.Offset(0, 10).Value = "X"
End If
If UFsais.Ch4.Value = True Then
ActiveCell.Offset(0, 11).Value = "X"
End If
If UFsais.Ch5.Value = True Then
ActiveCell.Offset(0, 12).Value = "X"
End If
If L1 = "Primaire" And Ch1 = True Then Sheets("ResEp").Activate
If L1 = "Maternelle" And Ch1 = True Then Sheets("ResMat").Activate
With ActiveSheet
[G39].Value = "X"
[I2].Value = CDate(UFsais.T1)
[D18].Value = UFsais.C1.Value
[D20].Value = UFsais.L2.List
[K18].Value = UFsais.L4.List
[E22].Value = UFsais.L3.List
[F25].Value = CDate(UFsais.T3)
[F27].Value = UFsais.T6.Value
[F31].Value = UFsais.T2.Value
[F33].Value = UFsais.T8.Value
[F35].Value = UFsais.T7.Value
[F37].Value = UFsais.T5.Value
End With
Unload Me
End Sub |
Partager