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

Skips the next line of code

Answer

Logs errors to a file automatically

Answer

Converts errors to warnings

Question 2

Which VBA object represents the currently active worksheet?

Accepted Answer

ActiveSheet

Answer

CurrentSheet

Answer

ThisSheet

Answer

FocusedSheet

Question 3

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

Accepted Answer

Application.GetOpenFilename()

Answer

FileOpen.Show()

Answer

Shell.OpenFileDialog()

Answer

Dialogs.ShowOpen()

Question 4

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

Accepted Answer

Workbook.Close SaveChanges:=False

Answer

Workbook.Exit(False)

Answer

Workbook.Quit(NoSave)

Answer

Workbook.Discard()

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.Sleep()

Answer

Wait.Pause()

Answer

Delay(5)

Question 6

How do you protect a worksheet using VBA so users cannot edit cells?

Accepted Answer

Worksheet.Protect Password:="pass"

Answer

Worksheet.Lock(Password)

Answer

ActiveSheet.EnableProtection(True)

Answer

Sheet.SetProtection("pass")