Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-27-2015, 05:33 AM
Jercook Jercook is offline Confused about 2 defferent uses of Now Function in Excel VBA Windows XP Confused about 2 defferent uses of Now Function in Excel VBA Office 2010 (Version 14.0)
Novice
Confused about 2 defferent uses of Now Function in Excel VBA
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Confused about 2 defferent uses of Now Function in Excel VBA conditional formatting - I am confused parachamk Excel 1 07-03-2014 09:54 AM
Confused about 2 defferent uses of Now Function in Excel VBA +IF(RAND()........) confused newbie jeffk Excel 6 05-28-2013 08:03 AM
Confused about 2 defferent uses of Now Function in Excel VBA Field Lookup - Confused lawnG Word Tables 1 01-31-2011 03:50 PM
cambria math in equation is defferent? iranacre Word 0 01-22-2010 02:58 PM
Confused about 2 defferent uses of Now Function in Excel VBA Need Backup/Export - confused! Robin12265 Outlook 2 06-04-2006 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft