Time Entry

[mike47338]

Is there any way to enter the current time in a selected sell by only
pressing 1 (one) key? (as opposed to Ctrl-Shift-

 

[Don Guillett]

a macro with a right click event?

 

[Gord Dibben]

Not that I know of.

How about a one-click button and some code.

Sub NOWTIME()
With ActiveCell
.Value = Format(Now(), "h:mm:ss AM/PM")
.Columns.AutoFit
End With
End Sub


OR you could run the code from a shortcut key combo CRTL + T

One less keystroke.

Gord Dibben Excel MVP

 

[mike47338]

Thanks. That was exactly what I was looking for.