Good morning/afternoon/evening based on time

		Microsoft Office Forums > Microsoft Word > Word VBA
Good morning/afternoon/evening based on time

FAQ

Thread Tools

Display Modes

01-03-2017, 01:01 PM

dwirony

Windows 7 64bit Good morning/afternoon/evening based on time

Office 2003

Advanced Beginner

Join Date: Oct 2016

Posts: 49

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PPT Progress Bar based on Time not the # of Slides	The Dutchman	PowerPoint	0	12-14-2016 09:59 AM
filtering a list based clock time	DPD16	Excel	8	01-06-2016 03:29 PM
Automatically Delete Slides based on current time	Pacman52	PowerPoint	2	07-16-2015 05:30 AM
Good Word-based Document Assembly Software?	Grahamers	Word	1	05-13-2013 04:42 PM
field value based on time of day	akraw	Word	3	03-26-2011 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:05 PM.