M
mikester104 via OfficeKB.com
I have a userform with a ton of code in it. I have these form as a workbook
that the company uses. It works fine on all the computers except four of the.
Everytime they enter in the phone number in the phone number fieild it brings
up COMPILE ERROR IN HIDDEN MODULE: USAs, USAs being the name of the userform.
Here is the code that in that textbox for the phone number.
Private Sub txtPhone_Change()
On Error Resume Next
If Len(txtPhone.Text) = 3 Then
txtPhone.Text = txtPhone.Text & Chr(45)
End If
If Len(txtPhone.Text) = 7 Then
txtPhone.Text = txtPhone.Text & Chr(45)
End If
txtPhone.MaxLength = 12
End Sub
Any help would be much appreciative. Could it be taht tehy do not have
correct refrence libraries that somehow got deleted?
that the company uses. It works fine on all the computers except four of the.
Everytime they enter in the phone number in the phone number fieild it brings
up COMPILE ERROR IN HIDDEN MODULE: USAs, USAs being the name of the userform.
Here is the code that in that textbox for the phone number.
Private Sub txtPhone_Change()
On Error Resume Next
If Len(txtPhone.Text) = 3 Then
txtPhone.Text = txtPhone.Text & Chr(45)
End If
If Len(txtPhone.Text) = 7 Then
txtPhone.Text = txtPhone.Text & Chr(45)
End If
txtPhone.MaxLength = 12
End Sub
Any help would be much appreciative. Could it be taht tehy do not have
correct refrence libraries that somehow got deleted?