Excel VBA Excel VBA 5

Question 1

Which VBA statement pauses execution for a specified number of milliseconds?

Accepted Answer

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

Answer

Application.Wait accepts a future time value; to pause for 1 second you pass Now plus a 1-second TimeValue.

Question 2

What is the purpose of the 'Option Explicit' statement at the top of a VBA module?

Accepted Answer

Forces all variables to be declared before use

Answer

Option Explicit requires every variable to be declared with Dim, preventing typos from creating unintended new variables.

Question 3

Which method deletes all content AND formatting from a range in VBA?

Accepted Answer

Range.Clear

Answer

Range.Clear removes cell values, formulas, formatting, comments, and hyperlinks — a complete reset.

Question 4

In VBA, which operator is used for string concatenation?

Accepted Answer

&

Answer

The & operator concatenates strings in VBA; while + can also work, & is preferred because it avoids type ambiguity.

Question 5

What does the 'ByVal' keyword mean in a VBA procedure parameter?

Accepted Answer

A copy of the argument is passed; changes don't affect the original

Answer

ByVal passes a copy of the variable, so any changes made inside the procedure do not affect the caller's variable.

Excel VBA Practice Test