Time Sensitive Message Box

[szymagic]

Hello all,

Is it possible to run a message Box from a specific date until someone opens the spreadsheet?

So I have 3 dates in question: April, August, December 26th. Is there a way to have a message box display on those dates up until the spreadsheet is opened a 2nd time? See Timeline...

April 1st - - - - - - - - - - April 26th - - - - - - - - - May 2nd - - - - - - - - June 18th- - - - - - - August 26th - - - - - - October 3rd - - ->>
No MsgBox...................MsgBox Displays - - - - - Opened.....................Opened.................MsgBox Displays - - - - Opened

So the MsgBox would be displayed May 2nd and October 3rd, but not June 18th.

Can this also be reoccurring indefinitely?

I'd be glad to explain anything if there is confusion! Thanks for the help in advance!

 

[RickXL]

Hi,

Yes, it sounds doable.

You will need to place the MsgBox code in your ThisWorkBook Module. You will also need to keep some details about when or how many times the workbook has been opened. That information will need to be retained. Retaining it in a, possibly hidden, worksheet would be the obvious choice.

So when the workbook is opened:

1. The Workbook_Open Even will be triggered.
2. That will check to see how many times the workbook has been opened and the current date.
3. It will then decide whether to display the MsgBox or not.


Regards,