VBA在创建Userform时冻结 [英] VBA Frozen while creating Userform

问题描述

在Excel VBA中创建Userform时，我正在更改命令按钮的名称。我不小心点击了页面上的其他地方而"名称"。字段为空或者包含非法字符。出现一个错误对话框，说明以下内容：
不是合法对象名称：" （它包括引号，这可能是我在"名称"字段中意外输入的内容）。问题是现在一切都冻结了。当我将光标移动到Visual Basic窗口或Excel电子表格
窗口上时，它显示为带有斜线的黑色圆圈，我无法单击任何内容。我害怕完全关闭Excel或VBA，因为我最近没有保存我的工作。有什么建议吗？

While creating a Userform in Excel VBA, I was changing the Name of a command button. I accidentally clicked elsewhere on the page while the "Name" field was either empty or had illegal characters in it. An error dialog box appeared that says the following: Not a legal object name: " (it included that quotation mark, which may have been what I had accidentally typed into the Name field). The problem is that everything is frozen now. When I move my cursor over the Visual Basic window, or over the Excel Spreadsheet window, it appears as a black circle-with-a-slash and I cannot click anything. I'm afraid to close it Excel or VBA entirely since I haven't saved my work very recently. Any suggestions?

推荐答案

创建时 Excel VBA ，....

While creating a Userform in Excel VBA, ....

这篇关于VBA在创建Userform时冻结的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！