how to create an excel popup on timer?

[nadavrock]

lets say i have a task. i put the start time in excel. i want excel to popup alert me when time is up. how do i do that?

 

[SpillerBD]

In Excel, Excel would have to be running first. You could build a VBA Event. There are some vulnerabilities to this running correctly if you run multiple sessions.
In Outlook(Desktop) may be better or similar. Though there is a move to the Online email services.
The best Reminder methods is the (probably) least known. Do a search on your Windows7 machine for "Task Scheduler". In Windows10, the Alarm Clock is better.

 

[Logit]

.
Here is a simple timer that pops up a Message Box at the end of the time you set.
Presently, the time is set to 10 seconds. You can edit that to any length time you require.

Sub StartTimer()
Static SchedSave
    If SchedSave <> 0 Then
    Application.OnTime SchedSave, "TimeOver", , False
    End If
    SchedSave = Now + TimeValue("00:00:10")     '<--- Ten seconds .. adjust time as required
    Application.OnTime SchedSave, "TimeOver", , True
End Sub


Sub TimeOver()


MsgBox "Your time is up !"


End Sub

Paste the above code into a regular module. Paste a button on the sheet and attach it to the "StartTimer" macro.