Digital clock on excel

**dominicb** · 02-28-2008, 06:27 AM

Good morning shilpz

Format cell A1 to a time format of your choice then run this macro. It will update the cell every second :

Public CntTme As Double
Sub StartClock()
Sheets("Sheet1").Range("A1").Value = Now()
CntTme = Now + TimeSerial(0, 0, 1)
Application.OnTime CntTme, "'" & ThisWorkbook.Name & "'!StartClock", , True
End Sub

HTH

DominicB

**shilpz** · 02-28-2008, 06:37 AM

where do i copy the code to i dont understand it i formated the cell A! to time
ad pasted the forumula on a button but when i click the button

can you plz send it to me in a xls file plz

thanks in advance

**dominicb** · 02-28-2008, 07:01 AM

Hi shilpz

Find zipped file, time.zip attached.

HTH

DominicB

**royUK** · 02-28-2008, 07:02 AM

I've put Domenic's code in this workbook, it's triggered when the workbook opens

**royUK** · 02-28-2008, 07:03 AM

You weren't there a minute ago Domenic!

**dominicb** · 02-28-2008, 07:24 AM

Hi royUK

Originally Posted by royUK

I've put Dominic's code in this workbook, it's triggered when the workbook opens

Great minds ... and all that kind of thing

I actually called the module from the Workbook_Open event, and also added something into the Workbook_BeforeClose event cancelling the OnTime macro which can cause an error when the file is closed.

DominicB

**Maltese Falcon** · 01-02-2012, 02:08 AM

Originally Posted by royUK

I've put Domenic's code in this workbook, it's triggered when the workbook opens

Hello Roy,
I tried your code and the clock works fine. It is exactly what I want as I require the clock to run automatically when I open the workbook. The only problem is that when I save and close the workbook it re-opens again automatically. If I shut down Excel completely (i.e. "EXIT") this does not happen. I do not always want to shut down Excel as I have other workbooks open. Is there a fix for this problem?
I am using Excel 2003 with Windows XP
Thank You
Maltese Falcon

**senjuti.sarkar** · 01-21-2012, 06:50 AM

It happend to me also, what I did is...just disable the macro...again when I reopen it, I enable the same.

Senjuti

**senjuti.sarkar** · 01-21-2012, 06:45 AM

Its so nice, its helped me too...Thanks..a lot

**harish bajaj** · 06-13-2012, 12:15 PM

Thanks for your Macro,It is working fine, again Thanks a lot.

Digital clock on excel

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

i dont get it

Re: Digital clock on excel

Re: Digital clock on excel

Re: Digital clock on excel

Re: Digital clock on excel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions