Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Keeping moving
In the cell D5 showing the time in the format: 9:23:43 (h:mm:ss), the time
will only update when I click on the cell D5. Therefore, is there any way to keep "ss" moving without manually click on the cell? Many thanks for any one advice. Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200807/1 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Keeping moving
I suppose you could use something like AutoHotKey
(http://www.autohotkey.com) to feed an F9 to Excel every second, but that seems sort of wasteful. Can you tell us why you need a live clock in an Excel spreadsheet? There are lots of clock gadgets you can run that would seem more efficient. -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.rolandschorr.com http://www.officeforlawyers.com Author - The Lawyer's Guide to Microsoft Outlook 2007: http://tinyurl.com/5m3f5q "wilchong via OfficeKB.com" <u43231@uwe wrote in message news:868978cd33cad@uwe: In the cell D5 showing the time in the format: 9:23:43 (h:mm:ss), the time will only update when I click on the cell D5. Therefore, is there any way to keep "ss" moving without manually click on the cell? Many thanks for any one advice. Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200807/1 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Keeping moving
Public nTime As Double Public Sub TimeDisplay() ActiveSheet.Range("D(").Value = Time nTime = Now + TimeSerial(0, 0, 1) Application.OnTime nTime, "TimeDisplay" End Sub Public Sub StopTimeDisplay() Application.OnTime nTime, "TimeDisplay", , False End Sub -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "wilchong via OfficeKB.com" <u43231@uwe wrote in message news:868978cd33cad@uwe... In the cell D5 showing the time in the format: 9:23:43 (h:mm:ss), the time will only update when I click on the cell D5. Therefore, is there any way to keep "ss" moving without manually click on the cell? Many thanks for any one advice. Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200807/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
Help keeping my cursor from moving to the end of the document. | Excel Discussion (Misc queries) | |||
Keeping leading 0's | Excel Discussion (Misc queries) | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
moving a pivot table graph and keeping the formatting | Charts and Charting in Excel |