Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compile error with Excel

Status
Not open for further replies.

MMund

Programmer
Oct 9, 2007
57
CA
I'm using some VBA with Excel 2003. My VBA contains the following code:
Code:
Private Sub txtAssocID_Change()
    If strCategoryChoice = "SUPPORT" And Len(Trim(Me.txtAssocID.Text)) = 6 Then
        With frmAccountability
            .Label2.TextAlign = fmTextAlignCenter
            .Label2.Caption = txtAssocID.Text
            .Show
        End With
    End If
End Sub
This works for me, but when I send it to an offsite user, who is running Excel 2000, she gets the following message:

Compile Error: Can't find project or library.

It appears to not like the Trim function in the If statement, at least that's what it's highlighting.

Ideas, anyone?

TIA,

MMund
 



Hi,

Sounds like a missing .dll.

Reload Office Excel.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 


not on mine.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top