79602719

Date: 2025-05-02 01:56:00
Score: 2.5
Natty:
Report link

I have a Module with OnTimer macros for a System Modal MsgBox to pop up every 30 mins to suggest I start a 5 Mins break. This gives way for a UserForm

I had to abandon the On Timer as it woud not trigger all the time, when App focus was not in Word where the 'Macro M reminder to Move WFH'.

I would like this solution as OnTimer uses virtually no CPU and battery charge when compared to a Timer with Do While DoEvents Loop, via monitoring Task Manager.

Struggled to find any solutions for a few weeks, before reverting back to a timer.

Reasons:
  • Blacklisted phrase (1.5): any solution
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: James Martin