Compile error with Excel

[MMund]

I'm using some VBA with Excel 2003. My VBA contains the following 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

 

[SkipVought]

Hi,

Sounds like a missing .dll.

Reload Office Excel.

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

 

[MMund]

On the user's PC?

 

[SkipVought]

not on mine.

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