Active X droop-down boxes not functioning on spreadsheet

[Ranger9348]

Hi All,

I have a spreadsheet with Active X drop-down boxes, which has been operating sucessfully on several computers, but now, it will not operate on 2 of them. The drop down boxes are not selectable and when I look at the code, it has stopped at the line:
Me.ComboBox1.ListIndex = -1
Can anyone let me know why this line has caused a problem after all this time?
Thanks in advance for any help given.

Bill

 

[Andrew Poulsom]

Welcome to MrExcel.

Look here:

Office Update breaks ActiveX controls | Excel Matters

 

[Ranger9348]

Hi Andrew,

Thanks for the reply. I deleted the .exd files, but I still have the same problem.

 

[Andrew Poulsom]

Some more options here:

Form Controls stop working after December 2014 Updates - The Microsoft Excel Support Team Blog - Site Home - TechNet Blogs