Chapter 1 Flashcards Preview

Excel VBA COPY > Chapter 1 > Flashcards

Flashcards in Chapter 1 Deck (28)
Loading flashcards...
1

standard VBA line continuation character sequence

a space followed by an underscore character

2

location to set macro security properties

File->Options->Trust Center->Trust Center Settings

3

Recommended security setting for macros

Disable all macros with notification

4

other locations of VBA

other members of Microsoft Office

5

VBA is these two types of languages

programming language

macro language

6

macro word origin

Greek makros

means large

7

You can customize your ____ _____ _____ with your own buttons that execute the macros you write.

Quick Access toolbar

8

Buttons for executing macros can also be added to this

the Ribbon

9

VBA can be used to create custom versions of these

worksheet functions

10

You can use VBA to develop your own special-purpose ___-____.

add-ins

11

VBA consists of these two types of procedures

Sub procedures

Function procedures

12

Function procedures return this

a single value

 

Example:

Function AddTwo (arg1,arg2)

    AddTwo=arg1+arg2

End Function

13

VBA manipulates these

objects

14

Objects can act as ____ for other objects.

containers

15

object model refers to

the arrangement of objects

16

Objects of the same type form this

a collection

17

Collections are themselves _____.

objects

18

You refer to an object by specifying its position in the object hierarchy with this

a dot separator

19

Objects have these which you can use VBA code to change or determine.

properties

20

How do you refer to an object's property

Combine the object name with the property name separated by a dot.

Example:

Worksheets("Sheet1").Range("A1").Value

21

Use these in VBA code to store values, text and property settings

variables

Example:

Interest = Worksheets("Sheet1").Range("A1").Value

22

A ____ is an action Excel performs with an object.

method

23

Specify a method by doing this

Combining the object name with the method, separated by a dot

Example:

Worksheets("Sheet1").Range("A1").ClearContents

24

VBA includes all of these three constructs of modern programming languages

variables

arrays

looping

25

First version of Excel and when it appeared

Excel 2

1987

26

First Excel version to use VBA, and year of release

Excel 5

1994

27

First version of Excel to support a million rows

Excel 2007

28

Excel 2016 online and mobile device versions do not support this

VBA