Hello everyone,
I am having a probably very easy problem here. I am trying to find out in what format VBA sets time and how I can work with times. I just want an easy script that tells the user "good morning", "good afternoon" and "good night".
This is what i have
Dim Dag As String Dim Tijd Tijd = Time If Tijd <= "12:00:00" Then Dag = "Good Morning" If "12:00:00" < Tijd <= "18:00:00" Then Dag = "Good Afternoon" If Tijd > "18:00:00" Then Dag = "Good Night"
When I have it like this it tells me all kind of weird stuff, so good night in the morning, etc. But I can't seem to find out how VBA handles times.
TIA
frank