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