Month:Date:Time:Seconds

[Ranjit kurian]

In my excel workbook the sheet1 is my Dashboard and sheet2, sheet3, etc...
are graphs , pivots etc...

Actually i need my Sheet1 Dashboard to display Monthate:Time:Seconds in a
cell, so that whenever i open it should view me and the seconds should be
moving(running)just like a watch....

 

[T Lavedas]

In my excel workbook the sheet1 is my Dashboard and sheet2, sheet3, etc...
are graphs , pivots etc...

Actually i need my Sheet1 Dashboard to display Monthate:Time:Seconds in a
cell, so that whenever i open it should view me and the seconds should be
moving(running)just like a watch....

Maybe something like this ...

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As
Long)

Sub Workbook_WindowActivate(ByVal Wn As Excel.Window)
With ActiveWorkbook.Sheets(1)
Do
.Range("A1").Value = Now()
DoEvents
Sleep 250
Loop
End Sub

Save the macro in the code section of ThisWorkbook object, maybe.
Format the Sheet 1, A1 cell to display seconds.

The one drawback is that macros security will need to be set at least
to Medium, which will require confirmation to enable every time the
workbook is opened. Or the macro will require a signature of a
trusted source (and I have never done that).

Tom Lavedas
===========
http://members.cox.net/tglbatch/wsh/

 

[Jacques ALARDET]

Hello Ranjit

I thinj thatb your watch is graphe radar with three series : 1 serie for
hour ; One serie four minute ; 1 serie for second

It is possible to calculate these series

J a c q u e s