Progress Message Box in Excel 1

[Stevo911]

Hi

I've written a marco to perform a series of operations on some data.
Is it possible to bring up a message, similar to a message box, excepting that it does not interfere with background calculations or require input from the user befor it can proceed. Ideally, is it possible that the 'message' could inform the user of the current process without requiring any input or interrupting the processes themselves.

Any help would be greatly appreciated.
Thank you

 

[shetlandbob]

Do you want to create your own form?

If so you can design one that has text etc... that gives the user information, and launch it as modeless, then the program will carry on in the background.

Just remember to close it at the end of the proces as well.

Robert Cumming

http://www.consultantengineer.co.uk

 

[PHV]

You may play with the Application.StatusBar property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886