"Processing" Pop up box
 

I have a macro that takes a couple of seconds to complete and since I
have the screen update turned off, I want a pop up box that will say
something like "Processing your information" with periods that "move".
The moving period concept will look like this:

this.
this..
this...
this....

Of course I don't want it to type "This" four times; I'm just showing
you how the periods should move.


--
Tha BeatMaker
------------------------------------------------------------------------
Tha BeatMaker's Profile: http://www.excelforum.com/member.php...o&userid=23998
View this thread: http://www.excelforum.com/showthread...hreadid=384068

"Processing" Pop up box
 

Would you consider using the status bar?

During processing:
Application.StatusBar = "Processing...."

Then, when done:
Application.StatusBar = FALSE

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=384068

"Processing" Pop up box
 

I use the statusbar at the bottom of excel's window to give the user the status.

Application.statusbar = "Processing this"
'do this
application.statusbar = "Processing that"
'do that
application.statusbar = false 'reset it when you're done.



Tha BeatMaker wrote:

I have a macro that takes a couple of seconds to complete and since I
have the screen update turned off, I want a pop up box that will say
something like "Processing your information" with periods that "move".
The moving period concept will look like this:

this.
this..
this...
this....

Of course I don't want it to type "This" four times; I'm just showing
you how the periods should move.

--
Tha BeatMaker
------------------------------------------------------------------------
Tha BeatMaker's Profile: http://www.excelforum.com/member.php...o&userid=23998
View this thread: http://www.excelforum.com/showthread...hreadid=384068

--

Dave Peterson