VBA macro to pop up messages at a specific time of the Day

[Eustace07]

Hi All

I have a macro which I want to apply to a daily tasklist process. I want the macro to pop up alert at specific times during the day. At the moment it only pops up one alert, how can I tweak it to show several alerts during the day?

Macro:

Please Login or Register  to view this content.

Other Alerts I want add and at which times:
11:00:00 - "Mid-day Statement run starts in an hour"
13:00:00 - "Afternoon Recs in 30min"
14:00:00 - "Review settlement starts in an hour"
16:35:00 - "EOD in starts in an hour"

Any ideas on this is much appreciated.

Thanks

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Eustace07]

Done. Thanks Pepe.

[jdop]

Seems simple. You can call multiple Application.OnTime events with different execution times.

Have each one call a different message sub. You could get more elegant and have a single message sub , and a select case structure based on the time of day , but keeping it simple would work too

[Eustace07]

I want to keep it simple by creating a single message sub. That said, I think I get your line of reasoning.

[Eustace07]

I've tried creating multiple Application.OnTime events for the various times but the macro is not working.

[Eustace07]

I don't understand why when I hit F5 the code runs but on its own it doesn't run at the set times. Please can anyone review this for me will be much appreciated? I have a feeling I'm getting something wrong. Thanks

Please Login or Register  to view this content.

[Eustace07]

Any help with this please? Sorry for asking one so many times.

[Eustace07]

I've tried below, it appeared to work for the first alert but it ceased after the first alert. Is there anything wrong with my procedure- Any ideas on this is much appreciated?

Module 1

Please Login or Register  to view this content.

Module2

Please Login or Register  to view this content.

[BMV]

Eustace07, your solution based on Excel is always on. I'm not sure it is good solution. It's better to use system task scheduler. For popup message you can use
MSG * "Mid-day Statement run starts in an hour"
Look switches for this command.

[Eustace07]

Thanks BMV. I'm trying to explore an excel solution if that's possible. System task scheduler is a good idea however not ideal in my current setting either my team.