View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rhowell100103 rhowell100103 is offline
external usenet poster
 
Posts: 4
Default macro to automatically insert static time in a cell

Bill,

I created this to allow users to enter the current date and time in a sheet.
I gave it a shortcut of Ctrl+d to run. (D for date for my users with poor
computer skills.)

Sub Current_Date_Time()
'
'
Application.SendKeys ("^; ^+;{RIGHT}")

End Sub

Ctrl+semicolon enters date then a space and Ctrl+Shift+semicolon enters
current time and the active cell will shift to the right.

Bill wrote:
I'm creating a sign-in worksheet for "retired volunteers" in a non-profit
organization. The sign-in sheet is to keep up with the time worked by
volunteers. As many are computer illiterate, I need the time to enter
automatically the easiest way when they log in so as to eliminate typing
errors. Maybe a macro? Can anyone help? Most have poor computer skills.
Thanks in advance.