Creating a reminder

RRB · #1 03-13-2024, 12:02 AM

Hi friends,

is it possible in Word to trigger an event every, let's say half an hour?
For instance, if I wanted to bug me to remind me to do a certain task every half hour could that be written in VBA?
Also being that this Mac would have to be run in the background as to say would it eat up system resources and slow Word down?

Thank you and have a good day!

Susan Flamingo

gmaxey · #2 03-13-2024, 08:22 AM

Yes it is possible. I have not done a full engineering or performance study but I would assume that process uses some system resources. Does it eat them up? I don't think so. You will have to try it for yourself:

Code:

Sub Reminder()
  Application.OnTime Now + TimeValue("00:30:00"), "ReminderMsg"
lbl_Exit:
  Exit Sub
End Sub
Sub ReminderMsg()
  If MsgBox("Wake up. Do you want to continue 30 minutes wake up calls?", vbYesNo, "Stop") = vbYes Then
    Reminder
  End If
lbl_Exit:
  Exit Sub
End Sub

RRB · #3 03-13-2024, 09:28 AM

Works perfectly, of course.

If I would substitute a user form instead of the message box (inserted frmMyform.show) with two control buttons for continuing or stopping the macro, how would I continue or cancel the macro? Just like from a msg box?

The hierarchy of VBA is still very unclear to me...

RRB · #4 03-14-2024, 03:54 AM

It just dawned on me, that forget about resource usage, when this macro is running I will not be able to run any other macros, right?
If so I will trash the idea I had in mind...bummmmmmmer

gmaxey · #5 03-14-2024, 08:02 AM

Why don't you try and see what happens? I'm sure that is some cases you will have to pepper you code with a few DoEvents statements.

Why do you want to do this anyway? Why don't you just set a reoccurring alarm on your smartphone, watch, Google calendar etc.?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook365 Reminder	dazzawm	Outlook	4	09-30-2023 05:06 AM
Why does task not set a new reminder?	Jennifer Murphy	Outlook	0	07-11-2018 05:47 AM
Reminder outlook 2016	nirv	Outlook	0	10-23-2017 12:59 PM
reminder for every 15 working days	araamuthan	Outlook	1	03-25-2015 11:49 PM
Help with Outlook reminder	katkota	Outlook	1	06-26-2010 06:18 PM