Progress message box

[harky]

Hi

Can anyone tell me how to display a message box for the duration of a macro running to display that it's working. I have a routine which is run over an incredibly large file and sometimes it appears to the user that the macro has crashed - I'd like to include some code to display "Macro in Progress" (preferablly flashing - although not essential) until the routine has finished - when it should tell the user "Macro complete"

Thanks in advance
Harky

 

[SkipVought]

Hi,

Not a MsgBox.

Check out the Application.StatusBar.

Skip,
[sub]
[red][/red]
[/sub]

 

[harky]

Hi SkipVought

I tried that and it works, but it's not always clear - some of the users really need something displayed in the centre of the screen

Harky

 

[SkipVought]

You can use a drawing shape textbox.

Skip,
[sub]
[red][/red]
[/sub]

 

[xlbo]

or a small userform with a textbox on it....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[macropod]

Hi harky,

Check out the following link. The code there may be what you're looking for.

http://j-walk.com/ss/excel/tips/tip34.htm

Cheers

[MS MVP - Word]