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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.