#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
conditional formatting - I am confused | parachamk | Excel | 1 | 07-03-2014 09:54 AM |
+IF(RAND()........) confused newbie | jeffk | Excel | 6 | 05-28-2013 08:03 AM |
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 |
Need Backup/Export - confused! | Robin12265 | Outlook | 2 | 06-04-2006 10:38 AM |