vba “编译错误:未找到方法或数据成员”与以前的工作代码

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/28484143/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-12 06:12:04  来源:igfitidea点击:

"Compile error: Method or data member not found" with previously working code

excelvbacompilationxlsm

提问by Scott Parker

As the title suggests, I'm getting the above error with code that was working 6 days ago.

正如标题所暗示的那样,我在 6 天前运行的代码中遇到了上述错误。

Code since omitted - apologies

DurationCombo is an ActiveX ComboBox which resides on Sheet1.

DurationCombo 是驻留在 Sheet1 上的 ActiveX ComboBox。

I can provide an image of the ComboBox: http://i.stack.imgur.com/eM7YD.png

我可以提供 ComboBox 的图像:http: //i.stack.imgur.com/eM7YD.png

I've seen all of the information regarding the Microsoft Updates and removed the anomaly yet this problem has since returned.

我已经查看了有关 Microsoft 更新的所有信息并删除了异常,但此问题又出现了。

EDIT:I am also unable to add ActiveX controls to anyExcel workbook. Bizarre, this one is!

编辑:我也无法将 ActiveX 控件添加到任何Excel 工作簿。奇怪,这就是!

EDIT 2:It may be an option to move from ActiveX controls to Form ComboBoxes. However, I have issues when converting. Any help with this would also be great - if it's possible!

编辑 2:从 ActiveX 控件移动到 Form ComboBoxes 可能是一个选项。但是,我在转换时遇到问题。对此的任何帮助也会很棒 - 如果可能的话!

采纳答案by Scott Parker

Got rid of KB2553154 (installed 11th February 2015) and success! Good luck to anyone else with this issue. My recommendation would be to research and uninstall any suspect Microsoft updates. That's the only thing that solved it for me (twice).

摆脱了 KB2553154(2015 年 2 月 11 日安装)并成功!祝其他有这个问题的人好运。我的建议是研究并卸载任何可疑的 Microsoft 更新。这是唯一为我解决了它的事情(两次)。

回答by Gary's Student

I had a similar problem and used Microsoft Fix it 51029mentioned here:

ActiveX

我遇到了类似的问题,并使用了此处提到的Microsoft Fix it 51029

ActiveX