Select Case List1(0) Case "00:00": hdeb = 1 Case "00:30": hdeb = 2 Case "01:00": hdeb = 3 ........ end select
hdeb = (DateDiff("n", TimeValue("00:00"), List1(0)) \ 30) + 1
Private Sub Sauver() Dim ff As Long Dim r As Long ff = FreeFile Open App.Path & "\sauvegarde.txt" For Output As #ff For r = 0 To 6720 Print #ff, Str(tabaht(r)) Next r Close #ff End Sub Private Sub Rappeler() Dim ff As Long Dim r As Long Dim sTemp As String ff = FreeFile Open App.Path & "\sauvegarde.txt" For Input As #ff For r = 0 To 6720 Line Input #ff, sTemp tabaht(r) = CInt(sTemp) Next r Close #ff End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub Picture8_Click() ' calcul du numéro Dim jour As Integer Dim hdeb As Integer Dim semaine As Integer Dim iddeb As Integer Select Case Combo15(0) Case "Lu": jour = 1 Case "Mar": jour = 2 Case "Mer": jour = 3 Case "Jeu": jour = 4 Case "Ven": jour = 5 Case "Sam": jour = 6 Case "Dim": jour = 7 End Select Select Case List1(0) Case "00:00": hdeb = 1 Case "00:30": hdeb = 2 Case "01:00": hdeb = 3 Case "01:30": hdeb = 4 Case "02:00": hdeb = 5 Case "02:30": hdeb = 6 Case "03:00": hdeb = 7 Case "03:30": hdeb = 8 Case "04:00": hdeb = 9 Case "04:30": hdeb = 10 Case "05:00": hdeb = 11 Case "05:30": hdeb = 12 Case "06:00": hdeb = 13 Case "06:30": hdeb = 14 Case "07:00": hdeb = 15 Case "07:30": hdeb = 16 Case "08:00": hdeb = 17 Case "08:30": hdeb = 18 Case "09:00": hdeb = 19 Case "09:30": hdeb = 20 Case "10:00": hdeb = 21 Case "10:30": hdeb = 22 Case "11:00": hdeb = 23 Case "11:30": hdeb = 24 Case "12:00": hdeb = 25 Case "12:30": hdeb = 26 Case "13:00": hdeb = 27 Case "13:30": hdeb = 28 Case "14:00": hdeb = 29 Case "14:30": hdeb = 30 Case "15:00": hdeb = 31 Case "15:30": hdeb = 32 Case "16:00": hdeb = 33 Case "16:30": hdeb = 34 Case "17:00": hdeb = 35 Case "17:30": hdeb = 36 Case "18:00": hdeb = 37 Case "18:30": hdeb = 38 Case "19:00": hdeb = 39 Case "19:30": hdeb = 40 Case "20:00": hdeb = 41 Case "20:30": hdeb = 42 Case "21:00": hdeb = 43 Case "21:30": hdeb = 44 Case "22:00": hdeb = 45 Case "22:30": hdeb = 46 Case "23:00": hdeb = 47 Case "23:30": hdeb = 48 End Select semaine = Combo16(0) iddeb = 336 * (semaine - 1) + 48 * (jour - 1) + hdeb ' fin du numéro Dim tabaht(6720) As Integer MsgBox (iddeb) MsgBox (tabaht(iddeb)) If tabaht(iddeb) = 1 Then MsgBox ("Réservation impossible car la plage " & List1(0) & " du " & Combo15(0) & " de la semaine " & Combo16(0) & " est déjà réservée !") Else MsgBox ("Le créneau " & List1(0) & " du " & Combo15(0) & " de la semaine " & Combo16(0) & " vous est réservé.") tabaht(iddeb) = 1 MsgBox (tabaht(iddeb)) End If End Sub