G
Guest
I need a button in a excel spreadsheet that when pressed inserts the current
time in a cell. Any ideas ?
time in a cell. Any ideas ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Hi
Control + : (that's Control + Colon) inserts current time to a cell.
Control + ; ( + semicolon) insets current Date
Control + : (that's Control + Colon) inserts current time to a cell.
Control + ; ( + semicolon) insets current Date
D
Dave Peterson
Why not just use the built in shortcut:
ctrl-:
(ctrl-colon aka ctrl-shift-semicolon)
ctrl-:
(ctrl-colon aka ctrl-shift-semicolon)
G
Gord Dibben
If you really want a button............
Assign this macro to a button.
Sub NOWTIME()
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub
Gord Dibben MS Excel MVP
Assign this macro to a button.
Sub NOWTIME()
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub
Gord Dibben MS Excel MVP
D
Don Guillett
range("a1")=time