LinkBack URL
About LinkBacks
I know that CTRL + ; will give me the current date.
I know that CTRL + SHIFT + ; will give me the current time.
Is there a keyboard shortcut that will give me both?
What keyboard shortcut gives me the CURRENT DATE and TIME?
I know that CTRL + ; will give me the current date.
I know that CTRL + SHIFT + ; will give me the current time.
Is there a keyboard shortcut that will give me both?
Well, I would guess you could do CTRL ; then Space then CTRL SHIFT ;
Create your own with a simple macro.
Assign the shortcut of your choice to the code above.
Please Login or Register to view this content.
What does the [ ] do? I know it sort of evaluates but it doesn't seem to do any difference her.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
It does evaluate, it's used to calculate a worksheet formula in vba. NOW() is a worksheet function so I have always assumed that it would need to be evaluated.Originally Posted by Jacc
Guess it's just another of those things that can be done in different ways.
Right. I recall now that the [] can be used to evaluate worksheetfunctions. I did some research and it does not exist as a worksheetfunction in VBA. If you search for Now in the object browswer it pops up but it's a true VBA function. Now we know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks