Microsoft patch KB3013126 - VBA error 424

[RossSarge]

KB3013126 has caused a runtime error '424' Object required on all Comboboxes in my sheet.
Does anyone know how we can comply with the patch and retain functionality.

Sub Override()
Worksheets("AssessSheet").Select
If Range("AL3").Value = 2 Then
ComboBox1.Enabled = False
Else
ComboBox1.Enabled = True
End If
End Sub

Thanks
Ross

 

[Debraj]

Hi ..

Welcome to the forum..

it must be "HotTopic" after update..

http://datapigtechnologies.com/blog/index.php/office-update-breaks-activex-controls/


try to delete .exd files from mentioned location.. and let us know.. if its still not working..

 

[Mike H..]

KB3013126 has caused a runtime error '424' Object required on all Comboboxes in my sheet.
Does anyone know how we can comply with the patch and retain functionality.

Sub Override()
Worksheets("AssessSheet").Select
If Range("AL3").Value = 2 Then
ComboBox1.Enabled = False
Else
ComboBox1.Enabled = True
End If
End Sub

Thanks
Ross

The Excel development team have published a fix.

http://blogs.technet.com/b/the_micr...top-working-after-december-2014-updates-.aspx

 

[RossSarge]

Hi, Thanks guys.

I used the fix supplied by Debraj however this seems to have caused other problems.

I ran this fix last week on some of our affected PCs, however now the excel files saved by those people are throwing up run time 32809 errors for those that were not affected.
Any suggestions?

 

[Marc L]

"Cannot insert object" error in an ActiveX custom Office solution after you install the MS14-082 security update

And search others links and from your new error code on Web !​

 

[shrivallabha]

This outbreak must have affected many people. In our office we have some files which generated reports without buttons (and unfortunately 'On Error Resume Next' masked those errors).

Delete Excel 8.0 folder in %temp% has worked for us.

I personally did not face this issue though as I tend to clean up temp folder periodically.

And there could be several files which might cause conflicts. Just to be sure of cleanup you can download and use tool like below:
https://www.piriform.com/ccleaner