Excel VBA Error Handling: Use Better, More Efficient Code, Fix Corrupt Files and Deliver Exceptional Results

Intro

When To Use Error Handling In Excel VBA (and When Not To)

On Error Statements To Fight The Evil Errors!

On Error Resume Next

On Error Goto 0

On Error Goto -1

Redirect To a Custom Label Using 'On Error Goto'

The ERR() Object

The ERR() Object

Using Line Numbers In VBA and The ERL() Function

A Trick To Number Your Macro Lines Easily!

Raising Your Own Errors For Testing (and When To Raise Them)

Customize Errors

Logging Errors To A .Txt or .Err File

Email Errors With Outlook (Optional)

Circular Dependencies Between Modules: What The Heck?!

Help For Specific Errors/Issues

Windows API Declaration Issues (and Tips)

64 Bit Excel VBA Issues

Compiling A Project, Dealing With Syntax Errors

Dealing With Compile Errors

Error Trapping Settings

Heal Corrupt VBA With The VBA Code Cleaner (Invaluable, Yet FREE)

Utilizing Error Numbers and Descriptions

Previous Lesson

When To Use Error Handling In Excel VBA (and When Not To)

X

Username

Password

Remember me

Forgot Password?

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account