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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1

After the error, look in tools=>References in the VBE and see if you see a
reference(s) marked as MISSING.

Also, look at what addins they have loaded. Find out what is common to
them and different from others.

--
Regards,
Tom Ogilvy


"mikester104 via OfficeKB.com" wrote:

> 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?
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200611/1
>
>

Have a look at Tools, References in the VBA project and see if anything is
marked as missing.

The code error can occur anywhere and is often misleading if there is a
missing library.

--
Robin Hammond
www.enhanceddatasystems.com


"mikester104 via OfficeKB.com" <u28159@uwe> wrote in message
news:68be179eba759@uwe...
>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?
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200611/1
>