• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Microsoft patch KB3013126 - VBA error 424

RossSarge

New Member
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
 

Mike H..

Active Member
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_microsoft_excel_support_team_blog/archive/2014/12/11/forms-controls-stop-working-after-december-2014-updates-.aspx
 

RossSarge

New Member
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?
 

shrivallabha

Excel Ninja
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
 
Top