Application.Statusbar not working as expected in E

问题:

I have an application that uses Application.Statusbar to update the status bar with progress of the macro. This works fine in Excel 2007 and 2010 but it doesn't display correctly in Excel 2013.

The application executes correctly but the status bar is not updated.

Any ideas appreciated.

回答1:

Thanks Siddharth. The DoEvents hint was what i needed. I have never needed it for Excel 2007 or 2010 but something must have changed in 2013 so that I need to yield control.

Have added DoEvents and now works fine.