activex error 32809

ww4612

Well-known Member
Joined
Apr 24, 2014
Messages
515
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?
Code:
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
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Did you delete them from your recycle bin and did you restart Excel.

Edit: and are you using Excel 2013?
 
Last edited:
Upvote 0
yes i deleted those .exd file completely and i restarted excel even windows. but the error still occur
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Last edited:
Upvote 0
when i compile those code i get 57121 error
and the system highligh this code:
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.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,212,933
Messages
6,110,756
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top