Dim W As Integer Call Calcule(DateTime.Date, DateTime.Time, W, Text3.Text) Text2.Text = CStr(W)
Private Sub Form_Activate() calcule Now, Text2, Text3 End Sub Public Sub calcule(D As Date, ByRef W As Control, ByRef P As Control) Dim quoi As Date W = Format(D, "ww", vbMonday, vbFirstFourDays) quoi = TimeSerial(Hour(D), Minute(D), Second(D)) P = "matin" If quoi > #2:00:00 PM# And quoi <#10:15:00 PM# Then P "après-midi": Exit Sub If quoi > #10:15:00 PM# Or quoi < #5:30:00 AM# Then P = "nuit" End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionOption Explicit Private Sub Form_Activate() calcule Now, Text2, Text3 End Sub Public Sub calcule(D As Date, ByRef W As Control, ByRef P As Control) W = Format(D, "ww", vbMonday, vbFirstFourDays) Select Case TimeSerial(Hour(D), Minute(D), Second(D)) Case #5:30:01 AM# To #2:00:00 PM# P = "matin" Case #2:00:01 PM# To #10:15:00 PM# P = "après-midi" Case Else P = "nuit" End Select End Sub