Chapter 1 Flashcards
standard VBA line continuation character sequence
a space followed by an underscore character
location to set macro security properties
File->Options->Trust Center->Trust Center Settings
Recommended security setting for macros
Disable all macros with notification
other locations of VBA
other members of Microsoft Office
VBA is these two types of languages
programming language
macro language
macro word origin
Greek makros
means large
You can customize your ____ _____ _____ with your own buttons that execute the macros you write.
Quick Access toolbar
Buttons for executing macros can also be added to this
the Ribbon
VBA can be used to create custom versions of these
worksheet functions
You can use VBA to develop your own special-purpose ___-____.
add-ins
VBA consists of these two types of procedures
Sub procedures
Function procedures
Function procedures return this
a single value
Example:
Function AddTwo (arg1,arg2)
AddTwo=arg1+arg2
End Function
VBA manipulates these
objects
Objects can act as ____ for other objects.
containers
object model refers to
the arrangement of objects
Objects of the same type form this
a collection
Collections are themselves _____.
objects
You refer to an object by specifying its position in the object hierarchy with this
a dot separator
Objects have these which you can use VBA code to change or determine.
properties
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
Use these in VBA code to store values, text and property settings
variables
Example:
Interest = Worksheets(“Sheet1”).Range(“A1”).Value
A ____ is an action Excel performs with an object.
method
Specify a method by doing this
Combining the object name with the method, separated by a dot
Example:
Worksheets(“Sheet1”).Range(“A1”).ClearContents
VBA includes all of these three constructs of modern programming languages
variables
arrays
looping
First version of Excel and when it appeared
Excel 2
1987
First Excel version to use VBA, and year of release
Excel 5
1994
First version of Excel to support a million rows
Excel 2007
Excel 2016 online and mobile device versions do not support this
VBA
