Tip of The Day Function Sought in Excel!
Posted by Jack J on December 13, 2001 12:25 AM
The Tip Of The Day Function in MSWord is sometimes a pain but then again it can be useful.
I would like to be able to apply this principle to an Excel workbook. What I am after is some code that will either open an Msg message or form, display said message or form for 5 seconds and then close. This procedure would run using the On_Open function event. I have something similar to this already but the procedure only displays a single message. The same message is repeated everytime the workbook is opened. I would like to record up to 31 messages that would display themselves over a month, one per day as the workbook is opened. The message would not repeat itself if the workbook were accessed more than once a day. After 31 days the original message would be displayed again in a loop format. Any suggestions on how best to tackle this problem would be welcomed.