Chapter 7

Question 1

When are apostrophes ignored as comment indicators in Excel VBA?

Answer 1

When they are contained within a set of quotation marks

(e.g. Msg = “Can’t continue”)

Question 2

Quick way to convert a block of statements into comments

Answer 2

From the VBE:

View->Toolbars->Edit

Select group of statements and click the Comment Block button

Question 3

The first character of a variable must be a _____.

Answer 3

letter

Question 4

Does VBA distinguish between uppercase and lowercase letters in variables?

Answer 4

No

Question 5

Cannot use these characters in a variable name

Answer 5

, $, %, &, !

spaces

periods

math operators

Question 6

Letting VBA handle your data typing results in these two issues

Answer 6

slower execution

inefficient memory use

Question 7

To get a slight performance increase use this instead of Integer for variable type

Answer 7

Long

Question 8

What is the default data type?

Answer 8

Variant

Question 9

What is the data type Variant?

Answer 9

changes type depending on what you do with it

Question 10

Use this statement as the first statement in code to force declaration of all variables

Answer 10

Option Explicit

Question 11

One benefit of using Option Explicit as first line

Answer 11

mis-spelled variables will be identified as not being typed

Question 12

Press this after typing the first two or three characters of a variable or reserved word or function to get selection list or auto-completion

Answer 12

Ctrl+space bar

Question 13

Example of dimensioning a variable

Answer 13

Dim YourName as String

Dim January_Inventory as Double

Dim RowNumber as Long

Dim X

(X is treated as a Variant)