Compile error in hidden module: USAs

  • Thread starter mikester104 via OfficeKB.com
  • Start date
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?
 
T

Tom Ogilvy

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.
 
R

Robin Hammond

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top