PDA

View Full Version : Show a Form During General Recalculations



ronjon65
11-16-2011, 10:47 PM
Is there a way to show a form or change the icon during calculations? I have some functions that take several seconds to calculate and when the user makes a change, they update. The problem is that it may not be obvious that Excel is updating. I would like a more obvious way of letting the user know that Excel is "working".

Rob342
11-18-2011, 02:22 PM
Look in Kbase, there is an article by DRJ might be what you are looking for


Rob

ronjon65
11-19-2011, 08:54 AM
Well, I didn't find anything there that worked...but I did find a few other gems :)

Rob342
11-19-2011, 09:44 AM
RonJon65

Is this what your looking for ? a small example

Rob