Current Time Display

**stevewilde** · 11-09-2009, 09:58 AM

I have the =NOW() entered in to a cell on my excel dashboard. Is there a code or other method that I could use to refresh the time every second so that the current time is always visible - Thanks

**sweep** · 11-09-2009, 10:29 AM

Hi,

Use the following module to display the current time in cell A1 (adjust the range as you require).

Run the StartClock and StopClock macros to do the obvious...

Please Login or Register  to view this content.

**stevewilde** · 11-09-2009, 11:34 AM

Worked a treat - thanks !!!!

**stevewilde** · 11-10-2009, 08:24 AM

One little problem. If I have the workbook open with the timer running, if I open another workbook, the time is auto displayed in that workbook aswell. How can I make the timer just work in the original worksheet??