Hi, everyone,
I've been trying making an Excel VBA procedure which uses ontime method to run itself periodically. This procedure will check the data and pop-up a remind window (UserForm) showing all items are due.
When this procedure is executing, I may be under the environment of IE or Outlook instead of staying in Excel. Is there an method to switch the "Focus" from current active application back to excel, so that I could see this message timely instead of waiting for my go back excel to see it?
I hope the feeling is at least like ICQ or MSN that no matter which application you are using, you will see the blink icon indicating there is a new message coming.
I've tried searching the archive and can't find this kind of info, so please kindly give me a hand on this issue.
Thanks a lot.
Hoki
I've been trying making an Excel VBA procedure which uses ontime method to run itself periodically. This procedure will check the data and pop-up a remind window (UserForm) showing all items are due.
When this procedure is executing, I may be under the environment of IE or Outlook instead of staying in Excel. Is there an method to switch the "Focus" from current active application back to excel, so that I could see this message timely instead of waiting for my go back excel to see it?
I hope the feeling is at least like ICQ or MSN that no matter which application you are using, you will see the blink icon indicating there is a new message coming.
I've tried searching the archive and can't find this kind of info, so please kindly give me a hand on this issue.
Thanks a lot.
Hoki