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
macro word origin
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
VBA can be used to create custom versions of these
You can use VBA to develop your own special-purpose ___-____.
VBA consists of these two types of procedures
Function procedures return this
a single value
Function AddTwo (arg1,arg2)
VBA manipulates these
Objects can act as ____ for other objects.
object model refers to
the arrangement of objects
Objects of the same type form this
Collections are themselves _____.
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.
How do you refer to an object's property
Combine the object name with the property name separated by a dot.
Use these in VBA code to store values, text and property settings
Interest = Worksheets("Sheet1").Range("A1").Value
A ____ is an action Excel performs with an object.
Specify a method by doing this
Combining the object name with the method, separated by a dot
VBA includes all of these three constructs of modern programming languages
First version of Excel and when it appeared
First Excel version to use VBA, and year of release
First version of Excel to support a million rows
Excel 2016 online and mobile device versions do not support this