“Compile error: Method or data member not found” w

2019-09-17 06:44发布

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

Code since omitted - apologies

DurationCombo is an ActiveX ComboBox which resides on Sheet1.

I can provide an image of the 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.

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

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条回答
可以哭但决不认输i
2楼-- · 2019-09-17 06:52

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).

查看更多
贪生不怕死
3楼-- · 2019-09-17 07:11

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

ActiveX

查看更多
登录 后发表回答