How to programmatically set Error Trapping in VBE

[Tim Zych]

When I use error handling, it will be ignored if VBE's Error Trapping
setting is set to "Break On All Errors".

Therefore the following code would produce an error.

On Error Resume Next
Msgbox 5/0

Is there a way to programmatically set Error Trapping to "Break On Unhandled
Errors"?

Thanks

 

[Barb Reinhardt]

I *think* this is what you're driving at.

On Error Resume Next
MsgBox 5 / 0
If Err <> 0 Then
MsgBox ("Error:= " & Err)
End If

 

[Tim Zych]

Barb,

if you set up an environment as I explained, you should see part of the
problem.

 

[Chip Pearson]

You can't change the error handling programmatically. (Well, I suppose
it is stored somewhere in the registry, so I guess it is technically
possible.) But generally, this is a manual setting.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Tim Zych]

Darn..thanks for confirming.