PDA

View Full Version : Waiting message



zennon
02-28-2007, 06:37 AM
I have created a marco that takes a minute or two to run due to the amount of data it shifts around. I would like a message to show the user that it is working and not to cancel their excel session because they think it's crached.

I have seen some thing like this before but I can't find it anywhere now.

Any help welcomed.
Thanks

Bob Phillips
02-28-2007, 06:50 AM
Create a simple userform with your message on it, and call the macro from the userform activate event. Then you just need to show the form.

lucas
02-28-2007, 07:42 AM
http://www.vbaexpress.com/forum/showthread.php?t=8661&highlight=status
http://www.vbaexpress.com/forum/showthread.php?t=8773&highlight=status

lucas
02-28-2007, 09:43 AM
Wait message---no progress bar just a message while macro runs from ozgrid forum see post#1 by Dave Hawley:
http://www.ozgrid.com/forum/showthread.php?p=54903

CCkfm2000
02-28-2007, 09:57 AM
why not use

Application.StatusBar = "Please wait!"

to remove message

Application.StatusBar = false

lucas
02-28-2007, 10:00 AM
There are lots of ways to do this....just depends on posters needs and abilities.

CCkfm2000
02-28-2007, 10:06 AM
i've done this with one of my big spreadsheets.

eg.


application.StatusBar = "Please wait! 1/3"



application.StatusBar = "Please wait! 2/3"



application.StatusBar = "Please wait! 3/3"


and it works!!

Bob Phillips
02-28-2007, 12:40 PM
Ain't quite as in your face as a form.

lucas
02-28-2007, 02:14 PM
Bob said "aint"

Bob Phillips
02-28-2007, 03:46 PM
Bob said "aint"

No, I said 'ain't', and purely in the vernacular to add to the emphasis if the message. It's an English thing.