Timestamp (Date+Time) macro?
Okay, I am trying to make it possible to time-stamp with a single command (i.e. Ctrl+t). Basically I want to make a macro that does "Ctrl+;, Space, Ctrl+:" but my Visual Basic knowledge is lacking and 'record' saves the data, not the keystrokes.
I've already figured out that Ctrl+; translates into (ActiveCell.Value = Date) and Ctrl+: to (ActiveCell.Value = Time) - however I don't know how to reword the commands to include both date and time in the same cell. Any help would be appreciated!
Mike
Try,
Sub DateTimeStamp()
With ActiveCell
.NumberFormat = "[$-409]m/d/yy h:mm AM/PM;@"
.Value = Now()
End With
End Sub
Then go to TOOLS>MACRO>MACROS (find the DateTimeStamp macro)>OPTIONS (set a shortcut key)
HTH
Casey
Paste this into a Module :
Sub DateStamp()
ActiveCell.Formula = Date & " " & Time
End Sub
Then you go to Excel, hit Alt + F8, select 'DateStamp', then select 'Options' and there you can specify e.g. Ctrl+t as a shortcut key combination.
Gabor
Try
Activecell.value = Date & " " & Time
HTH
Jason
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks