| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to set current time
I need a button in a excel spreadsheet that when pressed inserts the current
time in a cell. Any ideas ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button to set current time
Hi
Control + : (that's Control + Colon) inserts current time to a cell. Control + ; ( + semicolon) insets current Date -- Regards Roger Govier "Mariner" wrote in message ... I need a button in a excel spreadsheet that when pressed inserts the current time in a cell. Any ideas ? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button to set current time
Why not just use the built in shortcut:
ctrl-: (ctrl-colon aka ctrl-shift-semicolon) Mariner wrote: I need a button in a excel spreadsheet that when pressed inserts the current time in a cell. Any ideas ? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button to set current time
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 On Wed, 26 Jul 2006 00:57:38 +0100, "Roger Govier" wrote: Hi Control + : (that's Control + Colon) inserts current time to a cell. Control + ; ( + semicolon) insets current Date -- Regards Roger Govier "Mariner" wrote in message ... I need a button in a excel spreadsheet that when pressed inserts the current time in a cell. Any ideas ? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Button to set current time
range("a1")=time
-- Don Guillett SalesAid Software "Mariner" wrote in message ... I need a button in a excel spreadsheet that when pressed inserts the current time in a cell. Any ideas ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel: is there a way of inserting the current time (what time it is right NOW) | Excel Discussion (Misc queries) | |||
| Having the current time inserted w/o updating the current time | Excel Worksheet Functions | |||
| Button/Script to create a new workbook from a current one. | Excel Worksheet Functions | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| Current time Current date. | Excel Programming | |||
Linear Mode
