Excel VBA Excel VBA Error Handling & Debugging

Question 1

Which statement is used to enable error handling and redirect execution to a labeled section in Excel VBA?

Accepted Answer

On Error GoTo

Answer

Try...Catch

Answer

Error Handle

Answer

Catch Error

Question 2

What does 'On Error Resume Next' do in VBA?

Accepted Answer

Allows execution to continue with the statement following the error

Answer

Stops execution immediately when an error occurs

Answer

Jumps to the next module in the project

Answer

Restarts the procedure from the beginning

Question 3

Which built-in VBA object is used to retrieve information about the most recently occurring error?

Accepted Answer

Err

Answer

ErrInfo

Answer

Error

Answer

LastError

Question 4

What is the purpose of the Err.Clear method in VBA?

Accepted Answer

Resets the Err object's properties to their default zero/empty values

Answer

Deletes all error history from the workbook

Answer

Clears the VBA error log file

Answer

Removes error-handling code from the procedure

Question 5

In VBA, what happens if a runtime error occurs inside an active error handler?

Accepted Answer

The current error handler is disabled and the error propagates to the caller

Answer

VBA automatically retries the failing statement

Answer

The error is silently ignored

Answer

VBA jumps to a nested error handler

Question 6

Which keyword is used at the end of an error handler to return execution to the main code flow?

Accepted Answer

Resume

Answer

Exit Handler

Answer

Return

Answer

End Error

Question 7

What does 'Resume Next' do when placed inside a VBA error handler?

Accepted Answer

Continues execution with the statement after the one that caused the error

Answer

Re-runs the entire procedure from the start

Answer

Jumps to the next procedure in the module

Answer

Exits the current subroutine immediately