Excel VBA Excel VBA Fundamentals & Syntax

Question 1

Which keyword is used to declare a variable in VBA?

Accepted Answer

Dim

Answer

In VBA, the Dim keyword is used to declare variables before they are used.

Question 2

What is the correct way to start a VBA subroutine?

Accepted Answer

Sub MySub()

Answer

A VBA subroutine begins with the Sub keyword followed by the subroutine name and parentheses.

Question 3

Which VBA data type stores True or False values?

Accepted Answer

Boolean

Answer

The Boolean data type in VBA holds only True or False values.

Question 4

What does the Option Explicit statement do in VBA?

Accepted Answer

Requires all variables to be declared before use

Answer

Option Explicit forces the programmer to explicitly declare all variables, reducing bugs caused by typos.

Question 5

In VBA, which operator is used for string concatenation?

Accepted Answer

&

Answer

The ampersand (&) operator is the standard VBA operator for joining strings together.

Excel VBA Practice Test