• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I make a Message Box to appear every 15 minutes.

Hello, I have created a simple Message Box that says:

MsgBox "Remember to check mails, Contact Us and Chat Conversations !"

Is there a way for it to appear every 15 or 20 minutes? I mean, I would like that message to pop up exactly at 15 or 20 minutes.

Is this possible?

Thank you again in advance.
 
See example.
Code in a normal module.
Timer starts when you open the workbook. (see ThisWorkbook section)
Timer is now set every 10 seconds for testing.
You can see in the code how to set for 15 minutes.
 

Attachments

  • message.xlsm
    12.5 KB · Views: 18
Back
Top