Here is some code that works in Excel 97. Naruto shipuden the hokage ppsspp. On the userform., two buttons to start and stop the timer and a label, lblCountdown, and this code [vba] Private Sub cmdStart_Click() nTime = nCount Call RunTimer End Sub Private Sub cmsdStop_Click() nTime = 0 End Sub [/vba] In a general module, this code [vba] Public Const nCount As Long = 30 ' secs Public nTime As Double Public Sub RunTimer() If nTime > 1 Then nTime = nTime - 1 UserForm1.lblCountDown.Caption = Format(TimeSerial(0, 0, nTime), 'hh:mm:ss') Application.OnTime Now + TimeSerial(0, 0, 1), 'RunTimer' Else Unload UserForm1 End If End Sub [/vba].

I'm using the code posted above for a countdown timer at the end of a process to give the user a chance to cancel before other macros get called. After the countdown, the rest of the macros proceed if the user doesn't cancel. The problem I have is that if the user clicks away to another application (to check email or browse the web) while macros are running before the userform is called to open, then the userform doesn't open and the timer doesn't start. Once they click back, the userform pops up and the timer start running.

You can insert a countdown timer using slides in Microsoft PowerPoint. Each slide will contain a number for the countdown and you can set the amount of time that should pass before the next slide.

Any way to make it so that the userform runs when Excel isn't active? Thanks in advance!