2010年(2013年)Excel VBA中的控制突破无限循环 [英] Control Break out of Infinite Loop In 2010 (2013) Excel VBA
问题描述
如果我使用新的Excel编写了创建无限循环的代码,则Ctrl + Break不再起作用.Esc键等也没有.
If I write code creating an infinite loop, with my new Excel, the Ctrl + Break no longer works. Neither does the Esc key, etc.
我在网上浏览了所有内容,似乎Microsoft存在一个错误,并不希望对其进行修复.
I've looked all over the web and it appears that Microsoft has a bug and doesn't care to fix it.
是否可以将Ctrl + Break功能重新引入VBA,所以如果将来发生这种情况,我不会丢失工作/强制关闭?
Is there a way to re-introduce the Ctrl + Break function to VBA so if this happens in the future I don't lose work / force close?
推荐答案
Alt + Esc.按住键,直到它断裂为止.
Alt + Esc. Hold down the keys until it breaks.
从Windows 7开始,这将在所有打开的窗口中循环.没关系,只要继续挤压它即可.
From Windows 7 on, this will cycle through all open windows. Pay no mind, just keep squeezing it.
这篇关于2010年(2013年)Excel VBA中的控制突破无限循环的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!