Time Entry
 

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

a macro with a right click event?

--
Don Guillett
SalesAid Software

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

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

On Thu, 18 Nov 2004 08:00:06 -0800, mike47338
wrote:

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

Thanks. That was exactly what I was looking for.

"Gord Dibben" wrote:

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

On Thu, 18 Nov 2004 08:00:06 -0800, mike47338
wrote:

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