"Processing" Pop up box

[Tha BeatMaker]

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.

 

[Ron Coderre]

Would you consider using the status bar?

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

Then, when done:
Application.StatusBar = FALSE

Regards,
Ron

 

[Dave Peterson]

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.