PDA

View Full Version : [SOLVED] Please wait... Message box



ilyaskazi
04-11-2005, 09:24 PM
While executing my macro, it manipulates data to my opened workbook. It takes some time for manipulation while going through each-n-every cell.

I need to show message box of "Please wait.." to the user, to notify them about what is going.

When user executes my macro, msg box must appear while manipulation is in progress in background. And then to go off from the screen when done.

Scottie P
04-11-2005, 09:29 PM
Hi Ilyaskazi.

do you just want a message box, or would you like something a bit more sophisticated?
There are a couple of Kb Entries that will fill that void of time for you:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=169

http://www.vbaexpress.com/kb/getarticle.php?kb_id=87

Not sure if this will work for your application or not.

Scott

Jacob Hilderbrand
04-11-2005, 09:29 PM
Check out this Kb Entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=169)

Scottie P
04-11-2005, 09:30 PM
LOL!!! Beat ya, Dude! LOL! :rotlaugh:

Jacob Hilderbrand
04-11-2005, 09:44 PM
Man, I think I need an instant replay on that one. :)

I wasted too much time using the [url] tags. :rofl: