Excel VBA Excel VBA Fundamentals & Syntax 2

Question 1

What is the VBA constant for a newline character in a message box?

Accepted Answer

vbCrLf

Answer

vbCrLf inserts a carriage return and line feed to create a new line in strings and message boxes.

Question 2

How do you write a comment in VBA code?

Accepted Answer

' comment

Answer

In VBA, a single apostrophe (') at the start of a line or inline makes the rest of the text a comment.

Question 3

What value does an uninitialized numeric variable hold in VBA?

Accepted Answer

0

Answer

Uninitialized numeric variables in VBA default to 0 automatically.

Question 4

Which VBA function converts a string to uppercase?

Accepted Answer

UCase()

Answer

UCase() is the VBA built-in function that converts all characters in a string to uppercase.

Question 5

What is the result of the VBA expression: 7 Mod 3?

Accepted Answer

1

Answer

The Mod operator returns the remainder of integer division, so 7 divided by 3 leaves a remainder of 1.

Excel VBA Practice Test