|
Posted to microsoft.public.excel.programming
|
|
|
Info Box that disappears by itself
Try a progress bar:-
http://www.cpearson.com/excel/Progress.htm
Mike
"B Baggins" wrote:
I have a very large spreadsheet which links to over 300 other spreadsheets.
When a specific macro is run to perform a filter there is long delay whilst
it performs it.
I am trying to figure out how to adise the user that there may be a delay at
the begining of the macro in a message box (e.g. "Calculating - please
wait"). At the end of the macro I want the box to close automatically.
Any ideas how I can do this?
Thank you in advance.
|