Macro for Message until macro not ended

[Herve_Rob]

Hi all,
Could anyone have a code that show message until the macro is not finished?
I have few macro in a XL file that run for 10 to 30 secondes.
I would like to show a messag like "in Progress" until the macro is not finish.

Regards

Herve

[SOS]

Herve,

You could use something like

Application.StatusBar = "......Please Wait.....Macro in progress......"

which would show that message (or whatever else you want) in the status bar (next to Start button).

Hope this helps

Seamus

[Herve_Rob]

Thanks Seamus

I would rather have a message / USF instead of a Status bar as nobody looks there.

Regards

Herve