Object doesn't support this property or method

[Guest]

Hi all,

Here is a weird message box, the title is Microsoft Excel and message is
"Object doesn't support this property or method", but it doesn't tell us
which object , which property , or where the problem happened and the
application can go on?

Clara

 

[Otto Moehrbach]

Clara
When you get an error message like that, it will be displayed in a box.
At the bottom of this box is a button that is labeled "Debug". Click on
that button. That will take you to the VBA code and the offending line of
code will be highlighted. If that doesn't help you much, post back and
include some or all of your code and tell us what line was highlighted. HTH
Otto

 

[JE McGimpsey]

What's on the line of code that's highlighted after you click Debug?

 

[Ed]

Is there a Debug button on the message box? What happens if you click
it?

If not, where is the code coming from? What is it trying to do?

Was the program written in-house? Or is it a commercial program?

Ed

 

[Guest]

Perhaps it's coming from an error handler that pops a message box showing the
error description.. In the VBE, go to Tools->Options. Then, in the General
tab, select "Break on All Errors" as the Error Trapping option. Try to
reproduce the problem and it should stop and take you to the line where the
error occurs.

 

[Guest]

Thank you very much. I think I find the reason.
First, there is ActiveX control button on a worksheet, I delet it and add a
new one. But I did not delete every occurance of the old button which is
scatter all around. The strang point is the VBE should stop the application
runnign instead of just give out a messagebox.

Thank you again

Clara