Excel Timers

[AEliason]

i'm looking for a code that will allow me to default a single cell back to a value of 0 after approx 5 minutes, does anyone know how to do this?

[si_the_geek]

Moved from FAQ forum

[RobDog888]

Use the Timer function.
From the Excel help file on how to use it...

Dim PauseTime, Start, Finish, TotalTime
If (MsgBox("Press Yes to pause for 5 seconds", 4)) = vbYes Then
    PauseTime = 5    ' Set duration.
    Start = Timer    ' Set start time.
    Do While Timer < Start + PauseTime
        DoEvents    ' Yield to other processes.
    Loop
    Finish = Timer    ' Set end time.
    TotalTime = Finish - Start    ' Calculate total time.
    MsgBox "Paused for " & TotalTime & " seconds"
Else
    End
End If