Thread: [Solved] Good morning/afternoon/evening based on time
View Single Post
 
Old 01-03-2017, 01:01 PM
dwirony dwirony is offline Windows 7 64bit Office 2003
Advanced Beginner
  
Join Date: Oct 2016
Posts: 49
dwirony will become famous soon enough
Default
Oops. Found a good solution. Here it is:

Code:
Select Case Time
        Case Is < TimeValue("12:00")
            msg = "Good morning"
        Case Is < TimeValue("16:00")
            msg = "Good afternoon"
        Case Else
            msg = "Good evening"
    End Select
Reply With Quote