Chapter 3 Flashcards Preview

Excel VBA COPY > Chapter 3 > Flashcards

Flashcards in Chapter 3 Deck (27)
Loading flashcards...
1

VBE stands for this

Visual Basic Editor

2

Path to get shortcut menus in VBE

right-click

3

two methods to display Project window in VBE

 

Ctrl+R

View->Project Explorer

4

two paths to display the Immediate window

Ctrl+G

View->Immediate Window

5

two uses of the Immediate window

executing VBA statements directly

debugging code

6

In Excel 2013, this was changed for the Help system

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

7

If you don't have Internet access and need help

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

8

add-in file extension

.xlam

9

VBE Project explorer window nodes (three types)

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

Modules node

Forms node

10

What does a Forms node contain?

UserForm objects (which hold custom dialog boxes)

11

How to add a new VBA module to a project

Select the project's name

Insert -> Module

 

or

 

Right-click the project's name

Choose Insert -> Module

12

To remove a module from a project

Select the module's name in the project window

File -> Remove "module name"

 

or

Right-click the module's name

Choose Remove "module name"

13

to export an object

Select object in the Project window

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

14

to import an object

Select the project's name in the Explorer window

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

Locate the file, and click Open

15

arrange Code windows

Window -> Tile Horizontally

Window -> Tile Vertically

16

switch among Code windows

press Ctrl+F6

17

Three types of VBA module code

Declarations

Sub procedures

Function procedures

18

single VBA module limit

64,000 characters

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

19

three ways to get code into a VBA module

enter the code directly

use the Excel macro recorder

copy the code from another module

20

use this to make code easier to read

indented lines using the Tab key

21

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

F5

22

F5 is short for this

Run -> Run Sub/User Form

23

what does "Option Explicit" mean at the top of a module

you must declare all variables

24

a VBA Sub procedure is also known as this

a macro

25

when copying code from websites, these two things sometimes occur

quote characters may need to be converted to simple quote characters

long lines wrap around

(erroneous statements will appear in red in the VBE)

26

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

Auto Syntax Check

Require Variable Declaration

Auto List Members

Auto Quick Info

Auto Data Tips

Auto Indent

27