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

0
votes

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
excelvbacompilationxlsm
Which line is giving you the error? - TheEngineer
I was able to reproduce the error if the DurationCombo ComboBox does not exist on Sheet1. Are you sure this box is named correctly and that it is still on Sheet1? - TheEngineer
100% positive it's there. And, it's line "With Sheet1.DurationCombo". I've added to the main question about further diagnostics. - Scott Parker
Did you also confirm what it is named? If it was copied and pasted at any point, it would have been automatically renamed. - TheEngineer
Just saw your edit. I also get the error if I disable ActiveX controls. Go to the Trust Center in Excel Options and make sure that "Disable all controls without notification" is not selected. - TheEngineer

2 Answers

0
votes

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

ActiveX

0
votes

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