Error Numbers in Error/Exit handlers

**ldoodle** · 05-18-2018, 11:43 AM

Hi,

I am doing this:

Please Login or Register  to view this content.

The problem is Err.Number is always 0 in the ExitHandler, even if if gets there via Resume ExitHandler in ErrorHandler, so the form always closes.

I only want the form to close if the error is really 0.

Thanks

**Logit** · 05-18-2018, 11:48 AM

.

Please Login or Register  to view this content.

What happens if you delete the "On Error Resume Next" line ?

**shg** · 05-18-2018, 11:48 AM

Please take a few minutes to reread the forum rules about thread titles, and then amend yours accordingly.

Thanks.

**Fluff13** · 05-18-2018, 11:58 AM

This line

Please Login or Register  to view this content.

resets the error, hence the error number will then be 0
For more info have a look here http://excelmatters.com/2015/03/17/on-error-wtf/

**AliGW** · 05-18-2018, 01:39 PM

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

Use concise, accurate thread titles.
Your post title should describe your problem, not your anticipated solution.
Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

**ldoodle** · 05-19-2018, 03:48 PM

Thanks all. I did try removing On Error Resume Next but it didn't change anything.

Fluff13 is right - the error number is always there in the error handler. I found a better way of deciding to close the form or not by checking if the current MailItem is Inspector or ActiveExplorer.