Alert that module code is complete?

**Redline** · 02-20-2009, 12:19 PM

I have a vba process that develops statistics/graphical output via SQL queries of pretty large datasets. This usually takes about 2min, so I run it via a form I've build, and then go do other work or play on the net, checking and rechecking if it has completed.

I do have a msgbox once the process is complete, but if i am not actively in an Excel window, I will not see it. Is there a way to force the windows taskbar to flash or something so i can see that my process is complete if i am not in an Excel window?

thanks,

Doug

**royUK** · 02-20-2009, 12:52 PM

Maybe if you use an messagebox that needs a response Excel will flash on the toolbar

**dustycrockett** · 02-20-2009, 01:13 PM

This code below causes the taskbar to flash when the loop is done. If your taskbar is set to auto-hide, it pops up and flashes.

Please Login or Register  to view this content.

**Redline** · 02-20-2009, 04:58 PM

excellent, thank you very much....

totally off topic, but any chance you've got that figured out for access as well?

**dustycrockett** · 02-20-2009, 05:13 PM

Originally Posted by Redline

excellent, thank you very much....

totally off topic, but any chance you've got that figured out for access as well?

sorry, access is like a big black box to me.

**royUK** · 02-21-2009, 03:22 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save