Script for Message Box and repeat every 10 minutes

[jcmckeon]

Hello All,

You've all been very helpful in the past, I hope you have an answer. Attached workbook - I want to have a Message Popup each time you open the excel workbook AND have this same message reappear every 10 minutes.

They people using this NEED EXTRA REMINDERS on the rules for using and I want to make sure that see if often. I save it a try with a sub called my_procedure and sub test to run it again but something is wrong.

Thanks in advance.

[Richard Buttrey]

Why not show us the code you're using?

Better still upload the workbook!

[nigelog]

In Module

Please Login or Register  to view this content.

In workbook open

Please Login or Register  to view this content.

This is set for 30 seconds to prove worked - change your time at "RunTime"

Edit:: Workbook close also needs "Stop Timer" macro to run

Please Login or Register  to view this content.

[jcmckeon]

Sorry I thought I did. It is there now Richard

[jcmckeon]

Hi Nigelog

Is there a way to colorize the message box or make font bigger?

[jcmckeon]

What about a user form to replace the message box so that I can design it better. Thoughts?

[jcmckeon]

Can the message box say open until the user closes it, then the timer starts

[nigelog]

Use a userform instead and design it how you wish. Call that from the timer

[nigelog]

Either can stay open until closed. I'm away from pc now so can't help unfortunately

[nigelog]

Inside message sub replace all with userform1.show and stoptimer. On userform close button starttimer userform1 unload.
Apologies, no square brackets on phone

[jcmckeon]

Hi All,

I've changed and now have a UserForm opening on open of worksheet. Click the close button to close. BUT I want the timer to reopen this userform every
minute or so (I want to adjust) and that the user HAS to click the close button. Obnoxious for sure, but it is the ONLY way to make people do the right thing.

Thank you in advance. See attached.

[jcmckeon]

Hi Nigelog, see below. I'm not that quick with VB. can you help? Thanks in advance.

[nigelog]

Just set time for message appearance