Object doesn't support this property or method

C

clara

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
 
O

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
 
E

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
 
V

Vergel Adriano

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

clara

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
 

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