Excel VBA Excel VBA Automation & Macros 2

Question 1

What is the purpose of the On Error GoTo statement in VBA?

Accepted Answer

Redirects execution to an error-handling label when a runtime error occurs

Answer

On Error GoTo Label redirects the execution flow to the specified label when a runtime error is encountered.

Question 2

Which VBA object represents the currently active worksheet?

Accepted Answer

ActiveSheet

Answer

ActiveSheet is the VBA property that references whichever worksheet currently has focus in the workbook.

Question 3

How do you open a file dialog box in VBA to let the user select a file?

Accepted Answer

Application.GetOpenFilename()

Answer

Application.GetOpenFilename() displays the standard Windows Open dialog and returns the selected file path.

Question 4

What is the VBA method to close a workbook without saving changes?

Accepted Answer

Workbook.Close SaveChanges:=False

Answer

Workbook.Close SaveChanges:=False closes the workbook and discards any unsaved modifications.

Question 5

Which VBA statement pauses a macro for a specified number of seconds?

Accepted Answer

Application.Wait Now + TimeValue("00:00:05")

Answer

Application.Wait pauses execution until the specified time, and adding a TimeValue offset creates an effective delay.

Excel VBA Practice Test