Home > IT Answers > Microsoft Windows > Automatically insert Date and Time
RamseyB
2,045 pts.
 Automatically insert Date and Time
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
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  June 24, 2011  2:26 pm  by  orangehat   1,445 pts.
All Answer Wiki Contributors:  orangehat   1,445 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If no ones know what would be the vb code to insert current date and time?

RamseyB
 2,045 pts.
 

Nice! Thank you I just could not bring it to mind

RamseyB
 2,045 pts.
 

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

Chippy088
 4,625 pts.
 

Thank you all

RamseyB
 2,045 pts.
 

CTRL ; for Date
CTRL : for time

Jcreedon
 10 pts.