Hello,
I would like to have a MsgBox that displays a warning (only) between 00:00 and 06:00 in the morning.
Between 06:01 and 23:59 there is no need for a warning.
Here's what I have right now:
Thanks in advance for any help,![]()
Sub Macro_01() If ................................ MsgBox "Opgepast, het is nu " & Format(Time, "hh:mm,") & vbNewLine & "werd de juiste datum geselecteerd?", vbExclamation, "Waarschuwing!" End If Workbooks.Open Filename:="xxx.xls" End Sub
Chris
Bookmarks