Time Pop-Up after every 10 min

[ikhan123]

Hello Everyone,　I need your help to create a pop-up in excel which will appear after every 10 min and 10 min should be variable (like any cell value where I’ll mention any time).　 Even if I am working on different application, excel should pop-up .　Time should start on my click and it should reset when I click on OK button and then again start on my click.

Thanks a lot forum in advance for helping me with this.


Regards,
ikhan123​

 

[pleeseemailme]

I think Pearson Software Consulting will get you what you need.

 

[ikhan123]

???

 

[ikhan123]

Hello Pleeseemalime,

How to use that code in excel..?

Sorry i not familiar with vba and all please guide me how to paste it and how to run this coding.

Any instruction or help or guidence on this..?

 

[Jim885]

Here.
Place this in a regular module;

Public RunWhen As Double
Public Const cRunIntervalSeconds = 10 ' <------- This number represents 10 seconds. Change to 600 for 10 minutes
Public Const cRunWhat = "Timer"  ' the name of the procedure to run
 
 Sub StartTimer()
    RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds)
    Application.OnTime EarliestTime:=RunWhen, Procedure:=cRunWhat, _
        Schedule:=True
End Sub
 Sub Timer()
   
    MsgBox "10 seconds has elapsed", , "Time is up"   ' Change 10 seconds to whatever you want that matches the time set in line 2
    
    StartTimer  ' Reschedules/Resets the procedure to run again and again
End Sub

 

[ikhan123]

Excellent.!!!

i got what i want...

Thank you very much i really appreciated.

can i ask you one little question???

To which procedure ("StartTimer" & "Timer") i need to assign macro [asking about button]????

Regards
ikhan123

 

[Jim885]

StartTimer.

Glad to help, and glad it worked out for you.