VBA On Error not catching errors

Question

Posting this here, in case it can help others. I was seeing some strange behavior where:

Sub somesub()
On Error GoTo Handler
    Dim x
    x = 1/0
    MsgBox("Done")
    Exit Sub
Handler:
    MsgBox("Error was handled")
End Sub

Was not catching the error.

There is a related question on SO already, at: Excel VBA Not Properly Breaking on Error, but it is asking about how to mitigate side effects of making one choice or another in the Error Trapping settings. This is asking why the error handling is not working at all.

possible duplicate of Excel VBA not properly breaking on error — SierraOscar
– SierraOscar, Commented Jun 24, 2015 at 15:33
Had to give you a kudos because I just had this same issue. The other post may be similar, but this post was far more helpful. — Tim
– Tim, Commented Nov 23, 2015 at 17:16

Community · Accepted Answer · 2017-05-23 11:44:40Z

3

It turned out that in the VBA editor, under

Tools>>Options>>General>>Error Trapping

I had "Break on All Errors" selected, which overrides any instruction in the code to GoTo or Resume on the error. Changing the selection to "Break on Unhandled Errors" resolved my issue.

Source for answer: Five tips for handling errors in VBA

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Nov 23, 2015 at 21:27

nwhaught

1,6221 gold badge19 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RonBreen · Accepted Answer · 2024-01-10 16:50:42Z

1

I have been struggling with this for months. Tools>>Options>>General>>Error Trapping was the exact solution !! Though I also structured my code to reset the error handler before every onerror goto label: statement as follows Put this above your desired onerror goto code:
onerror goto -1 '<<--- found in a different post that this resets the handler

answered Jan 10, 2024 at 16:50

RonBreen

111 bronze badge

Collectives™ on Stack Overflow

VBA On Error not catching errors

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related