Countdown Timer

What exactly do you mean? do you mean you will visible see it count down every second or just on opening you want to see time left to occurence?

yes mate,

I just want to see the following at any time so contiually counting if poss..

DD HOURS MINUTES SECONDS

anybody??????????????

"...contiually counting if poss.. "

given the topic title of 'cvountdown', you have yet to specify where the countdown starts & ends. if it's related to data in a file, make sure to specify where it is & what you want to happen when the limit is reached.

Sorry..all I want to do for example is set up a document which when I open there is a timer which is contiually counting down ie to the olympics ...so it looks something like this....

17 Days 06hrs 17mins 12secs until the ....

hope this makes sense..if it's too involved dont worry

and will this be working of a cell in your spreadsheet or can the date/time its counting down to be in the vba?

vba

Add this formula to your sheet:

=ABS(SECOND(NOW())-60)&" seconds left"

Then in a standard module add:

Public myStop As Integer

Private Sub Worksheet_Activate()
'Standard module code.
Call Recalculate
End Sub

Public Sub Recalculate()
'Standard module code.
'This starts the timer!

On Error GoTo Err
On myStop <> 0 GoTo Err
Calculate
Application.OnTime earliesttime:=Now + TimeValue("00:00:01"), _
procedure:="Recalculate"
End
Err:
End Sub

Public Sub myEnd()
'Standard module code.
myStop = myStop + 1
End Sub

Public Sub myReSet()
'Standard module code.
myStop = 0
End Sub

Then run Sub Recalculate().

P.S. I added this after I posted the above:

=ABS(DAY(NOW() +12)-1) & "Days " & ABS(HOUR(NOW())-24) & "hrs " & ABS(MINUTE(NOW())-60) & "mins " & ABS(SECOND(NOW())-60) & "secs"

This formula will count down the way you want, I Think!
I guessed on the start date Monday August 9th? 12 days in the formula above?

thank you