Excel Timers

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?

Moved from FAQ forum

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

VB Code:

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