Can't find project or library error

JohnSearcy
07-09-2010, 07:59 AM
I have program that used to work on this computer (before reinstalled XP and Office) and worked any other computer. I have a form button coded to show the userform and when activated, it gives me a compile error that states " Can't find project or library" on this line of code at first (others will happen after):

Private Sub UserForm_Initialize()

With CUSTOMERNAMEComboBox

X = Worksheets("Numbers").Range("C5")

.List = Worksheets("Customers").Range("A3:G" & X - 1).Value

End With

End Sub

This still works on any other computer but mine. I even have another very similar bit in a different book that doesn't error at all. The help file says something about diplaying a reference dialog box, but not quite sure. There are other similar compile errors in this book also. Something simple I'm missing?

Thanks

Bob Phillips
07-09-2010, 08:21 AM
Not sure, but trying going to Tools>References in the VBIDE, and if you have any items with the text MISSING, uncheck them.

JohnSearcy
07-09-2010, 08:53 AM
I did go and uncheck a missing box (MISSING:refedit control - something like that) and it worked. But you have to do that for each individual book if the error shows up. Thanks for the reply!

Bob Phillips
07-09-2010, 02:40 PM
No, not really. It is caused by incompatible versions, so you need to develop on the lowest Excel version that you will deploy to.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum