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


"RB Smissaert" wrote:

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

That was what I suspected, but no missing references.

RBS

"JMB" wrote in message
...
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).


"RB Smissaert" wrote:

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