Thread: I need to display "Good Morning" or "Good Evening" based on NOW()
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
  
Posts: 1,089
Default I need to display "Good Morning" or "Good Evening" based on NOW()
Wesley

try:

If Right(Now, 8) < "12:00:00" Then
MsgBox "Good Morning"
Else
MsgBox "Good Afternoon"
End If

Regards

Trevor


"Wesley" wrote in message
...
Been working on this for hours and just can't seem to figure it out.

TIA

Wesley


Reply With QuoteReply With Quote