excel 2007 vba, how to get into debugging mode after runtime error

[Rainer]

Hi,

I recently changed from Office 2003 to Office 2007. I found out that if a
runtime error occurs in an Excel 2007 vba code, there is no more option to
enter debugging mode!! Take this for an example:

Sub test()
MsgBox 1 / 0
End Sub

When the faulty line is executed, I get a message "error, division by zero",
and there are two icons OK and HELP. But where is the DEBUG icon, where I
can jump to that line and have the content of all variables preserved?? I
definitely need that feature!

 

[Steve Rindsberg]

Hi,

I recently changed from Office 2003 to Office 2007. I found out that if a
runtime error occurs in an Excel 2007 vba code, there is no more option to
enter debugging mode!! Take this for an example:

Sub test()
MsgBox 1 / 0
End Sub

When the faulty line is executed, I get a message "error, division by zero",
and there are two icons OK and HELP. But where is the DEBUG icon, where I
can jump to that line and have the content of all variables preserved?? I
definitely need that feature!

I get the debug icon here when I run that.

In the IDE, check Tools, Options, General tab, error trapping section.
Try "Break on all errors"

 

[Rainer]

That is the solution, many thanks.
Rainer

I get the debug icon here when I run that.

In the IDE, check Tools, Options, General tab, error trapping section.
Try "Break on all errors"

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================