activex error 32809

[ww4612]

the code below runs perfect on some pc. but there is an error 32809 on one of our laptop. there can be different error code everytime it runs on that laptop. any solution?

Sub tt()
With Sheets(1)
.ComboBox1.List = Application.Transpose(Range(.Cells(1, 5), .Cells(1, 22)))
.ComboBox2.List = Application.Transpose(Range(.Cells(1, 5), .Cells(1, 22)))
End With
End Sub

 

[MARK858]

Possibly due to last weeks windows updates. See the links below.

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

Office Update breaks ActiveX controls | Excel Matters

 

[ww4612]

i tired to remove those .exd file. but the error still occur

 

[MARK858]

Did you delete them from your recycle bin and did you restart Excel.

Edit: and are you using Excel 2013?

 

[ww4612]

yes i deleted those .exd file completely and i restarted excel even windows. but the error still occur

 

[starl]

Did you create the workbook in Excel 2010 and then open it in Excel 2007? If so, you 'll have to recompile and Save in Excel 2007.
Version may not matter..I have not tried Excel 2013.

 

[ww4612]

the code is created in excel 2013 and also texted in excel 2013. those 2 computer use the same OS and same excel version. I also tested the code on a computer without that update but it still not works. i don' think it has anything to do with that update.

 

[starl]

The Excel 2007 I tested did not have the update either. Have you tried recompiling on the problem system?

Update: I just tested a workbook (created on a system with the update) in Excel 2013 (on a system without the update), ran into the 32809 error, compiled, saved, closed, opened - and it worked.

 

[ww4612]

when i compile those code i get 57121 error
and the system highligh this code:

.ComboBox1.List = Application.Transpose(Range(.Cells(1, 5), .Cells(1, 22)))

error 32809 no longer appear. but the different error start appear every time i open the workbook.

 

[Andrew Poulsom]

Does your ComboBox have the ControlSource property set?