baffling: method or datamember not found

  • Thread starter Thread starter RB Smissaert
  • Start date Start date
R

RB Smissaert

Have a commercial .xla add-in with a number of userforms, modules and class
modules.
Used by at least 100 users without a problem.
One user however gets a compile error: method or data member not found.
This happens when in a normal module a control is referenced on one of the
userforms:

MainForm.ReporttxtDescription.Text = strMessage

Now ReporttxtDescription is a VB6 .ocx based on a VB6 RichText control.
This .ocx was made to bypass security problems with the regular .ocx.

What I don't understand though is why this can't compile with this one user
and fine with all the others.
Text is a property of this control and the control is fine in the references
in the VBE.
The whole Office setup is bang standard with Excel 2002.
Grateful for any suggestions what could be the problem here.

RBS
 
Do you have any missing references? In VB Editor check Tools/References and
see if that user has any missing.

I think that sometimes when Excel searches its references for a particular
item it crashes when one is missing (even though the missing reference did
not contain the item it needed).
 

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

Back
Top