VBA用户界面工具箱附加控件对话窗口未显示 [英] VBA userform toolbox additional controls dialogue window not showing
问题描述
在使用MS Excel（Outlook，Word或Power Point）以及使用VBA时，我创建一个用户窗体。工具箱显示控件选项卡和16个表示各种控件的图标。当我右键单击工具箱控制区域的一些空白空间时，会出现一个菜单，列出顶部的附加控件和其下方的两个灰色选项。当我选择附加控件时，会出现一个旋转的蓝色圆圈，然后消失，没有任何反应。我的理解是，此时应该打开一个对话框，我应该可以选择一些额外的控件。
。
我尝试过的
在另一台计算机上创建用户表单，然后将其导入到该表单。没有成功。
修复MS Excel。这导致完全重新安装，我相信我不得不重新输入我的产品密钥。没有成功
如下所述重置各种注册表项：文章。没有成功。
问题描述这里，但是没有解决方案，只是为了让人想添加的东西。
设置MS Excel以兼容模式...但是在桌面图标的属性下没有列出作为选项的兼容性模式。
以管理员身份运行，即使我的Windows帐户具有管理员权限。没有更改。
使用ccleaner和明智的注册表清理器清理注册表。
以安全模式运行Excel excel.exe / s。在标题栏中用（安全模式）确认。没有成功。
我的系统
Windows 10
MS Office Professional 2013 - 32
（请注意，我不知道添加的水晶报告）
附加信息
我在另一台运行相同版本的MS Office的Windows 10机器上尝试过，它在那里工作，所以它不应该只是Windows 10的问题。我的机器是从Windows 7 - 64升级。另一台机器是从Windows 8升级。
所以我刚刚创建了一个新的Windows用户帐户，我尝试了那里出现了这个帐号的对话框。我的账户不会出现Windows真的很恨我8）hehehe。至少现在我们知道它的SOMETHING与我的用户帐户/配置文件有关。
我找到了一个解决方案，花了2-3个晚上的问题。原来是一个非常简单和不直观的修复。
我的问题是当我右键单击工具箱时，我甚至没有看到菜单中的附加控制选项。
点击userform，使其被选中。
现在去工具和附加控件不再是灰色的。 ：）
While using MS Excel (Outlook, Word, or Power Point as well apparently) and using VBA, I create a userform. The toolbox shows up showing controls tab and 16 icons representing various controls. When I right click in some empty space in the tool box control area, a menu comes up listing "additional controls" at the top and two greyed out options below it. When I select "additional controls" a spinning blue circle appears briefly then disappears and nothing happens. It is my understanding that a dialogue box should open at this point and I should be able to select some additional controls.
I have spent about a day scouring the net and various solutions to the problem. I noticed the problem while trying to follow a video on how to data scrape for my personal project which I asked for help here.
What I have tried
creating a user form on another computer and then importing it to this one. no success.
Repairing MS Excel. This resulted in a full reinstall I believe as I had to re enter my product key. No success
Resetting various registry key as mentioned in this article. no success.
KB 369383 as mention as part of the process above. no success.
Issue described here but no solution, just a work around to something to what the person was trying to add.
Setting MS Excel to run in compatibility mode...but there was no compatibility mode listed as an option under properties for the desktop icon.
Running as administrator even though my windows account has admin rights. no change.
Cleaning the registry with both ccleaner and wise registry cleaner.
Running Excel in safe mode using excel.exe /s. confirmed with (safe mode) in the title bar. No success.
My System
Windows 10
MS Office Professional 2013 - 32
(Note, no crystal reports added that I am aware of)
Additional Info
I tried it on another windows 10 machine running same version of MS Office and it worked there, so it should not solely be a windows 10 issue. My machine was an upgrade from windows 7 - 64. The other machine was an upgrade from windows 8.
So I just created a new windows user account and I tried it in there and the dialogue box comes up for that account. It just will not come up for my account. Windows really does personally hate me 8) hehehe. At least now we know that its SOMETHING to do with my user account/profile.
I found a solution to 'my' problem after spending 2-3 nights over this. It turned out to be a very simple and not-so-intuitive fix.
My problem was that when I right-click on the Toolbox, I do not even get to see the "Additional Control" option in the menu.
Click on the userform, so that its selected. Now go to Tools and Additional Controls is no longer greyed out. :)
这篇关于VBA用户界面工具箱附加控件对话窗口未显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
