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
"Compile error: Method or data member not found" with previously working code
提问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 更新。这是唯一为我解决了它的事情(两次)。