Digital clock on excel

[shilpz]

hello

Is ther any way i can get a digital clock on excel that changes or updates every second, i know htere is a "=now()" function but this does not change per second

thanks in advance

[royUK]

See Andy's examples here

http://www.andypope.info/fun/clocks.htm

[shilpz]

thanks bro
thats what i want but i need it to be on a one individual cell

[dominicb]

Good morning shilpz

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

Please Login or Register  to view this content.

HTH

DominicB

[shilpz]

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]

Hi shilpz

Find zipped file, time.zip attached.

HTH

DominicB

[royUK]

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

[royUK]

You weren't there a minute ago Domenic!

[dominicb]

Hi 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]

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]

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

[senjuti.sarkar]

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

Senjuti

[harish bajaj]

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