Excel VBA Technology & Digital Applications 5

Question 1

Which VBA function pauses code execution for a specified number of seconds?

Accepted Answer

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

Answer

Application.Wait accepts a time value and pauses VBA execution until that time is reached, commonly used with Now + TimeValue for a delay.

Question 2

What is the correct way to reference a named range called 'SalesData' in a VBA formula assigned to a cell?

Accepted Answer

Range("A1").Formula = "=SUM(SalesData)"

Answer

Named ranges can be referenced directly by name inside formula strings assigned to the Formula property, just as they are in worksheet formulas.

Question 3

When declaring a dynamic array in VBA, which statement resizes it while preserving existing data?

Accepted Answer

ReDim Preserve arr(newSize)

Answer

ReDim Preserve changes the array's upper bound while keeping existing element values; ReDim alone would erase all data.

Question 4

Which VBA property determines whether formula calculation in Excel is automatic or manual?

Accepted Answer

Application.Calculation

Answer

Application.Calculation can be set to xlCalculationAutomatic or xlCalculationManual to control when Excel recalculates formulas.

Question 5

In VBA, which built-in constant represents a carriage return and line feed combination when building multi-line strings?

Accepted Answer

vbCrLf

Answer

vbCrLf is the VBA constant equal to Chr(13) & Chr(10), representing Windows-style line endings used in strings and message boxes.

Excel VBA Practice Test