Chapter 3

Question 1

VBE stands for this

Answer 1

Visual Basic Editor

Question 2

Path to get shortcut menus in VBE

Answer 2

right-click

Question 3

two methods to display Project window in VBE

Answer 3

Ctrl+R

View->Project Explorer

Question 4

two paths to display the Immediate window

Answer 4

Ctrl+G

View->Immediate Window

Question 5

two uses of the Immediate window

Answer 5

executing VBA statements directly

debugging code

Question 6

In Excel 2013, this was changed for the Help system

Answer 6

All help information is on the Internet and is displayed in a web browser

Question 7

If you don’t have Internet access and need help

Answer 7

download copy of the Help system from the Microsoft site using another computer

Question 8

add-in file extension

Answer 8

.xlam

Question 9

VBE Project explorer window nodes (three types)

Answer 9

Microsoft Excel Objects (Charts, Sheets, and This Workbook)

Modules node

Forms node

Question 10

What does a Forms node contain?

Answer 10

UserForm objects (which hold custom dialog boxes)

Question 11

How to add a new VBA module to a project

Answer 11

Select the project’s name

Insert -> Module

or

Right-click the project’s name

Choose Insert -> Module

Question 12

To remove a module from a project

Answer 12

Select the module’s name in the project window

File -> Remove “module name”

or

Right-click the module’s name

Choose Remove “module name”

Question 13

to export an object

Answer 13

Select object in the Project window

Choose File -> Export File (or press Ctrl+E)

Question 14

to import an object

Answer 14

Select the project’s name in the Explorer window

Choose File -> Import File (or press Ctrl+M)

Locate the file, and click Open

Question 15

arrange Code windows

Answer 15

Window -> Tile Horizontally

Window -> Tile Vertically

Question 16

switch among Code windows

Answer 16

press Ctrl+F6

Question 17

Three types of VBA module code

Answer 17

Declarations

Sub procedures

Function procedures

Question 18

single VBA module limit

Answer 18

64,000 characters

(any number of sub procedures, function procedures and declarations)

Question 19

three ways to get code into a VBA module

Answer 19

enter the code directly

use the Excel macro recorder

copy the code from another module

Question 20

use this to make code easier to read

Answer 20

indented lines using the Tab key

Question 21

Execute a procedure by placing the cursor anywhere within the text and typing this

Answer 21

F5

Question 22

F5 is short for this

Answer 22

Run -> Run Sub/User Form

Question 23

what does “Option Explicit” mean at the top of a module

Answer 23

you must declare all variables

Question 24

a VBA Sub procedure is also known as this

Answer 24

a macro

Question 25

when copying code from websites, these two things sometimes occur

Answer 25

quote characters may need to be converted to simple quote characters long lines wrap around (erroneous statements will appear in red in the VBE)

Question 26

Code settings options (6) in the Editor tab under Tools-\>Options

Answer 26

Auto Syntax Check Require Variable Declaration Auto List Members Auto Quick Info Auto Data Tips Auto Indent