Application.Statusbar在Excel 2013中无法正常工作 [英] Application.Statusbar not working as expected in Excel 2013

问题描述

我有一个应用程序使用Application.Statusbar更新状态栏与宏的进展。这在Excel 2007和2010中工作正常，但在Excel 2013中无法正确显示。

应用程序正常执行，但状态栏未更新。

任何想法赞赏。

解决方案

谢谢Siddharth。 DoEvents提示是我需要的。我从来没有需要Excel 2007或2010，但在2013年必须改变，所以我需要控制。

添加了DoEvents，现在工作正常。 p>

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.

解决方案

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.

这篇关于Application.Statusbar在Excel 2013中无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！