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

vbTab

Answer

vbNewLine

Answer

vbNull

Question 2

How do you write a comment in VBA code?

Accepted Answer

' comment

Answer

// comment

Answer

/* comment */

Answer

-- comment

Question 3

What value does an uninitialized numeric variable hold in VBA?

Accepted Answer

0

Answer

Null

Answer

Empty

Answer

Nothing

Question 4

Which VBA function converts a string to uppercase?

Accepted Answer

UCase()

Answer

Upper()

Answer

ToUpper()

Answer

StrUpper()

Question 5

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

Accepted Answer

1

Answer

2

Answer

3

Answer

4

Question 6

In VBA, which scope modifier makes a variable visible throughout the entire module?

Accepted Answer

Private

Answer

Public

Answer

Dim

Answer

Static