Automatically insert Date and Time

2,115 pts.
Tags:
Office 2007
Visual Basic
Visual Basic Script
Windows 7 64-bit
Hey there, stupid question but I am having a complete brain fart.  One of my Win7 users wants to create a keyboard shortcut to automatically insert the date and time within Office 2007 programs.  I know there is a easier way to do this than creating a vb script, can anyone refress me on the process?

Software/Hardware used:
windows 7, office 2007
ASKED: June 21, 2011  6:00 PM
UPDATED: May 23, 2012  9:47 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

In word it’s alt-shift-D
not sure about Excel

In Microsoft Word, use the following shortcut keys to enter the current system date and time.
Alt + Shift + D Insert the current date.
Alt + Shift + T Insert the current time.
This works in Word 2000, Word 2002, Word 2003 and Word 2007.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RamseyB
    If no ones know what would be the vb code to insert current date and time?
    2,115 pointsBadges:
    report
  • RamseyB
    Nice! Thank you I just could not bring it to mind
    2,115 pointsBadges:
    report
  • Chippy088
    In excel you could just use the =today() function in a cell? Obviously this will change every day you use the spreadsheet, so copy and paste values to make it permanent. That should be possible in VB
    4,625 pointsBadges:
    report
  • RamseyB
    Thank you all
    2,115 pointsBadges:
    report
  • Jcreedon
    CTRL ; for Date CTRL : for time
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following