Excel VBA Excel VBA 4

Question 1

Which VBA collection object contains all open workbooks in the current Excel instance?

Accepted Answer

Workbooks

Answer

The Workbooks collection is a property of the Application object and holds all currently open Workbook objects.

Question 2

What does the MsgBox function return when the user clicks the Cancel button?

Accepted Answer

vbCancel (2)

Answer

MsgBox returns the VBA constant vbCancel, which has an integer value of 2, when Cancel is clicked.

Question 3

Which statement is used to define a reusable block of code that does NOT return a value in VBA?

Accepted Answer

Sub

Answer

A Sub procedure performs actions but does not return a value, unlike a Function which returns a result.

Question 4

How do you copy a range in VBA without including the clipboard (direct value copy)?

Accepted Answer

destRange.Value = sourceRange.Value

Answer

Assigning .Value directly between ranges transfers data without using the clipboard or triggering a copy animation.

Question 5

What does the Cells property return when called as Cells(2, 3) on a worksheet?

Accepted Answer

The cell in row 2, column 3 (C2)

Answer

Cells(row, column) uses numeric row and column indices, so Cells(2,3) refers to row 2, column C — cell C2.

Excel VBA Practice Test