Process bar

[prshnthvn]

Hello Everyone,

I want to display a simple userform with just the word "Processing" in it to indicate the users that the macro is still running while the macro is running.

How can i bring a userform when the macro is running and close it when the macro as done the work?

Thanks in advance,
Prashanth

[Bob Phillips]

Take a different approach, launch the userform at the start, call the macro from there, then close the form when the macro returns control.