Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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-;) |
#2
|
|||
|
|||
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-;) |
#3
|
|||
|
|||
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-;) |
#4
|
|||
|
|||
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-;) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time entry | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |