View Single Post
  #2   Report Post  
Andy Brown
 
Posts: n/a
Default

Start recording a macro. In the "Record Macro" dialog, change the macro name
to "Date_Time" (without the quotes), make the shortcut key CTRL+T (capital
T), make sure it's stored in This Workbook, click OK.

Stop Recording.

Press ALT+F8, highlight Date_Time in the listbox, click Edit. Replace
everything between the "Sub" and "End Sub" lines with

ActiveCell.Value = Now

Press ALT+Q to quit the VBE. Back in the worksheet, use the CTRL(+Shift)+T
shortcut to call it.

HTH,
Andy