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

Jumps to line number 0 of the procedure when an error occurs

Answer

Resets the error counter variable to zero

Answer

Enables the system-default VBA error handler

Question 2

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

Accepted Answer

0

Answer

-1

Answer

Nothing

Answer

Null

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

Place 'On Error Resume Next' at the start of every procedure

Answer

Use empty error handlers to silently ignore all errors

Answer

Display a generic MsgBox for every error regardless of type

Question 4

What is 'error propagation' in VBA?

Accepted Answer

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

Answer

Copying error messages between open workbooks

Answer

Automatically correcting formula errors in a worksheet

Answer

Logging errors to an external database or file

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.Create "Custom error message"

Answer

Throw New Error("message")

Answer

Error.Raise("Custom", 1000)

Question 6

Which range of error numbers is reserved for user-defined errors raised with Err.Raise in VBA?

Accepted Answer

512 to 65535

Answer

1 to 100

Answer

200 to 400

Answer

1000 to 9999

Question 7

Which pattern ensures cleanup code (like closing files or releasing objects) always runs even if a runtime error occurs in VBA?

Accepted Answer

Use a GoTo to an exit label for normal flow plus Resume to the same exit label from the error handler

Answer

Place cleanup only inside the error handler block

Answer

Call cleanup exclusively at the top of each procedure

Answer

Wrap all cleanup calls in separate On Error Resume Next blocks