Excel VBA Excel VBA Error Handling & Debugging 3

Question 1

What is the effect of using 'On Error GoTo 0' in a VBA procedure?

Accepted Answer

Disables any currently active error handler in the procedure

Answer

'On Error GoTo 0' disables the currently active error handler, causing VBA to revert to its default unhandled-error behavior for any subsequent errors.

Question 2

What does the Err.Number property return when no error has occurred in VBA?

Accepted Answer

0

Answer

When no error has occurred, Err.Number returns 0, which is why 'If Err.Number <> 0' is the standard pattern for detecting whether an error happened.

Question 3

Which error handling approach is most appropriate for production VBA code that needs to respond differently to multiple error types?

Accepted Answer

Use a GoTo handler with a Select Case block on Err.Number

Answer

A GoTo error handler with a Select Case on Err.Number lets you apply specific logic per error type, resulting in robust and maintainable error handling.

Question 4

What is 'error propagation' in VBA?

Accepted Answer

An unhandled error bubbling up the call stack to the calling procedure

Answer

Error propagation occurs when a procedure has no error handler (or re-raises the error), causing the error to move up the call stack to the calling procedure.

Question 5

What is the correct syntax to raise a custom user-defined error in VBA?

Accepted Answer

Err.Raise Number, Source, Description

Answer

Err.Raise allows you to generate a custom error by specifying an error number, source, and description, enabling custom error signaling within procedures.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Excel VBA Error Handling & Debugging 3