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

'On Error GoTo' is the VBA statement that redirects execution to a specified error handler label when a runtime error occurs.

Question 2

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

Accepted Answer

Allows execution to continue with the statement following the error

Answer

'On Error Resume Next' instructs VBA to continue executing with the statement immediately following the one that caused the error.

Question 3

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

Accepted Answer

Err

Answer

The 'Err' object contains properties like Number, Description, and Source that provide details about the last error that occurred.

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

Err.Clear resets the Err object's Number, Description, and Source properties to their default values (0 and empty strings).

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

If an error occurs within an error handler, VBA disables that handler and passes the error up to the calling procedure's error handler.

Excel VBA Practice Test