PDA

View Full Version : Solved: Timer based messages



jwise
12-06-2007, 09:16 AM
I'm looking for some guidance on how this would be implemented. Please note that this is not the ultimate goal, but if I can do this, then I know how to handle the other details.

I want to start a "timer" when the user opens the spreadsheet, and put out a message with a MsgBox like "10 minutes have elapsed". My guess is there must be some event code that would gain control, else a macro would essentially "wait" and the user would not be able to do anything until the timer popped. Is this clear?

figment
12-06-2007, 09:22 AM
look through here

http://www.vbaexpress.com/forum/showthread.php?t=15852

Bob Phillips
12-06-2007, 09:30 AM
See http://www.xldynamic.com/source/xld.XtraTime.html

jwise
12-06-2007, 10:21 AM
Thanks for the references. I did a poor job with Google... I'm beginning to think that success is related to how well one searches on Google.

VBAX is a fantastic resource. Thanks to the responders again.