Imbedding an auto-update Clock in excel
 

-Im trying to imbed a clock in an Excel sheet that will automaticall
update both hours/minutes/seconds. Any ideas???-

- The date was straightforward... -

Thanks,
And

--
Message posted from http://www.ExcelForum.com

Imbedding an auto-update Clock in excel
 

Hi Andy

See
http://www.mvps.org/dmcritchie/excel/datetime.htm
far down on the page.

HTH. Best wishes Harald

"a_ndy2003_uk " skrev i
melding ...
-Im trying to imbed a clock in an Excel sheet that will automatically
update both hours/minutes/seconds. Any ideas???-

- The date was straightforward... -

Thanks,
Andy


---
Message posted from http://www.ExcelForum.com/

Imbedding an auto-update Clock in excel
 

Chip Pearson has a nice Clock example on his downloads page:
http://www.cpearson.com/excel/download.htm

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"a_ndy2003_uk " wrote in
message ...
-Im trying to imbed a clock in an Excel sheet that will automatically
update both hours/minutes/seconds. Any ideas???-

- The date was straightforward... -

Thanks,
Andy


---
Message posted from http://www.ExcelForum.com/

Imbedding an auto-update Clock in excel
 

Thanks for the help guys! I took Harald's code, pasted it into a module
then ran:


Public Sub Auto_Open()

Sheets("Control Panel").Select

Application.Run "clock"

End Sub


And it worked!

Thanks agai

--
Message posted from http://www.ExcelForum.com

Imbedding an auto-update Clock in excel
 

Although it is working, when i close the workbook, it automaticall
re-opens the workbook!! very strange!!

Module1:

Public Sub Auto_Open()
Sheets("Control Panel").Select
Application.Run "clock"
End Sub

Module2:

Sub clock()
ActiveWorkbook.Worksheets(1).cells(1, 1).Value = _
Format(Now, "hh:mm:ss")
Application.OnTime (Now + TimeSerial(0, 0, 1)), "clock"
End Sub

I made the Application.Run "clock" code in Module1 a comment and i
stopped so its definately that.

Any ideas

--
Message posted from http://www.ExcelForum.com

Imbedding an auto-update Clock in excel
 

Any ideas ??! !??
Why do you think the clock macro starts with
If stopit = True Then Exit Sub
and why did you remove it ?

Best wishes Harald

"a_ndy2003_uk " skrev i
melding ...
Although it is working, when i close the workbook, it automatically
re-opens the workbook!! very strange!!

I made the Application.Run "clock" code in Module1 a comment and it
stopped so its definately that.

Any ideas?