Pop up messages according the date of the month

Hello

I use this code(Provided by Mr Alan) that works fine.

Please Login or Register  to view this content.

My problem is that when the specific dates of the code are in weekends or Holidays, user does not see the messages and forget to do the duties.

I need if specific days of the month that appear in the code(10,15,20,25,30) are in weekends OR Holidays the pop up message to appears the last working date BEFORE that day.

In My example as Tomorrow date is in the Holidays List, the message for DAY 15 of the month should appear today.

Thanks in advance for any assistance here!

Hi

I would recommend a sub that is run before the one in the post, which sets the 5 dates. So it looks to see if its a weekend and then adjusts.

Something like

Please Login or Register  to view this content.

then replace if Day(Now()) > dateCheck1 etc.


I havent tested it, but that is the approach i'd play with.

You could even set it up on a separate sheet using the same weekday formula and then look at that sheet

nathansav

Thank you but Not sure how to handle it!

ragulduy

Thanks for that. Unfortunately this(running the code) does not appears anything. It should appears the data of column B? Should it?

YES. This works great and gives the correct results. Thank you.

May i ask this?

If i want in another application to use your code for different dates(let's say 2 ,10;22;28 of the month) will this code works for me?

ooooooooaaaaooooooooo!!! Thank you so much!!