View Single Post
 
Old 04-27-2015, 05:33 AM
Jercook Jercook is offline Windows XP Office 2010 (Version 14.0)
Novice
 
Join Date: Aug 2010
Location: West Valley Utah
Posts: 13
Jercook is on a distinguished road
Default Confused about 2 defferent uses of Now Function in Excel VBA

I found that if I use msgbox Now it returns 4/27/2015 6:14:01 am

If I use Select case now
case 1,7: msgbox "It's the weekend"
case else: msgbox "It's a weekday"

it works so it must be returning integers. Searching Help doesn't explain how the Now function can work in both of these cases.

Any comments on this would be helpful in my understanding of how this
Now function works.

Thanks

Jerry
Reply With Quote