Good morning/afternoon/evening based on time

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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:20 AM.