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