Reminder in VBA
Posted on 2014-03-07
I'd like to create a reminder using VBA - the concept is fairly straightforward BUT I don't want the reminder to interfer with other macros...
For example, I sit at the PC for a long time each day and I'd like the reminder to tell me to have a stretch every 45 minutes and save my work every 30 minutes.
I was thinking of using Application.OnTime to show a userform and then when the userform is acknowledged it would restart the countdown to the next reminder.
I'm not sure what the traps and pitfalls are to having this kind of code in my project. If anyone has thoughts / sample code I'd be glad if you could share :-)
PS - needs to work in both Word and Excel - no references to cells, tables etc.