Excel showing "Not responding"

[Rasm]

If I do very time consuming calculations (by VBA code) - then after very little time - Excel shows "Not responding". I get around that by having a counter - and then updating my application.statusbar property with a counter in brackets - so now it no longer give me the "Not responding message". So that is all good - however after 2 hours of so the statusbar stops updating - I simply get the circular "hourglass" - I can see that the application is still running (using windows 7 - can place my mouse on the taskbar on the buttom and it shows "running") - so if I let it keep on trucking - it will eventualy finish. I also know my application is still running by using Ctrl+Break - then debug. If I force the application.statusbar - then it become active again.
Any idea how I can force the application.statusbar to remain live and not fall asleep?

[Admin]

Hi,

A wild guess. Add DoEvents.

[Excel Fox]

Or use



With Application
.ScreenUpdating=Not .ScreenUpdating:.ScreenUpdating=Not .ScreenUpdating
End With

[Rasm]

I will try that thanks

[Excel Fox]

Any updates?

[Rasm]

Was out of town - have not tried yet - But I will for sure

[Rasm]

Fox
Tried the screenupdating - thanks for trying - did not do the trick. I will put that on the hook - then fix it at the end of it all. I did not try the do event suggestion. I have never done a do event before.

[Excel Fox]

You'll have to do that at the beginning and ending of the loop (if you are using one that is)

[Rasm]

hmmm - had this working - so as long as the activesheet has focus - It keeps updating. However if I switch to i.e. my email and then come back to xl2007 - it appears to have hung up (statusbar does not update) - however if I let it continue - it does finish. Dont waste time on it - just one of Excels quirks. I think it manages memory very badly. But I do appreciate all the help. Even if I am slow at answering at times.