Active X Objects in worksheet problems

[gjp55]

Hi,

I have problem regarding Active X boxes in a worksheet. I will be working on the code and click the save button which works fine. The problem comes when I close the workbook (even if I select no to saving changes). I get object errors on various listboxes where it can not fine the listbox object. I have the excel spreadsheet saved a various stages of development where the early versions save on but as soon as I go into the code , this can set the errors off when I come to close the file.

I have been reading a few posts about problems with Excel worksheets and active x objects and how they dont work well together.

I have tried somebody else running the file on another pc and they still get the error.

Does anybody have any idea have any idea how to solve this ?
I can provide a sample of the file it this helps ?

Thanks

 

[RoryA]

Sounds to me like a code problem rather than an activex problem. If you click Debug-Compile in the VBEditor, do you get error messages?

 

[gjp55]

Hi Rory,
Yes the code compiles fine.
Im getting pretty desperate to fix this now.
Thanks
gjp55

 

[gjp55]

I also get runtime 1004 error "Unable to get the object property of the OLEobject Class"

 

[RoryA]

Do you have any code in the BeforeClose event? Are the activex controls bound to ranges on sheets directly (e.g. using ListFillRange or LinkedCell)?

 

[gjp55]

Nothing in the beforeclose event. The listboxes are populated by a ListFillRange.

 

[RoryA]

And which code is running when the error occurs? (a listbox click/change event?)
Do you specifically need ActiveX controls rather than Forms ones?

 

[gjp55]

I have just tried this without populating the listboxes and i get if I close, i get a compile error stopping at the first label being referenced in the code. It doesn't think the label exists ?

 

[RoryA]

What label and what code?

 

[gjp55]

I guess if I this issue cant be resolved then i will have to try the form control listboxes. Are there any limitations with these ?