Screen While Macro's Run

[cfer]

Is it possible to have a Screen displayed with text/graphic, while the Spreadsheet is loading, and during the execution of the Macro's, also when one has to save the file. The spreadsheet is OK on a fast machine, but when on an olser machine it takes 2 or 3 minutes or longer to do the calculations. This way they have something to look at, and know that it is still working?

Thanks

 

[stevebausch]

I have an idea. Chance are the real wizards have a better technique. I hang around here for the humility factor

One idea is to allocate a range off in the 'corner' of a sheet; paint it up as you desire, and use Application.Goto TheRange.
If you get creative, you could have overlapping ranges, and Application.Goto a different range as the process occurs. A weak form of animation, but better than nothing.

If you are printing, have your 'screen' on that sheet; when you call .printout, whatever is visible on that screen will be shown

 

[rg]

There is a technique for displaying a customizable message box for the user to see while a macro is running. It's posted at Aaron Bloods website at http://www.XL-logic.com.
Can't remember the exact file but it should be easy to find in 'VBA macros" section.
Hope this helps.

 

[Richie(UK)]

...or you could go for the option of some sort of 'Progress Indicator'. Do a search on those words if your interested - I'm sure its been covered before. If not then repost as I have some routines somewhere that may be of use.