Term
|
Definition
| Series of commands and functions that you can initiate whenever you want to perform a particular task. Use of term is a carryover from earlier spreadsheet versions. Same as a "procedure" in VBA terminology. |
|
|
Term
|
Definition
| Visual Basic for Applications programming language. A descendant of BASIC programming language that is used in all Office products as well as some other types of software. |
|
|
Term
|
Definition
| Visual Basic Editor embedded within each application (Tools - Macros - Visual Basic Editor). All macros are stored here and can be edited or added here. Provides advanced editing capabilities including automatic syntax checking, tips and quick information, color coded programs for readability. |
|
|
Term
|
Definition
| Collection of Macros located in the VBE. You can place several macros in one module or create new modules for each macro. Modules can be renamed in the properties window. |
|
|
Term
|
Definition
| Displays the visual basic code for a macro. |
|
|
Term
|
Definition
| Displays variables and how they change as a macro is run. Useful in debugging macros. Located under "View" on the VBE menu. |
|
|
Term
|
Definition
A macro in visual basic. Three types:
-Sub Procedure - performs an action such as copying a cell.
-Function Procedure - returns a value (such as in a user defined function).
-Property Procedure - creates customized properties for objects. |
|
|
Term
|
Definition
| Located in the VB code to help clarify purpose and meaning of the macro. Designated with an apostrophe and color-coded green. |
|
|
Term
|
Definition
"Set of rules specifying how you must enter certain commands. You must follow the syntax precisely or the macro will not run. In general:
Sub Procedure_Name()
<Visual Basic Commands and Comments>
End Sub" |
|
|
Term
|
Definition
| Detail steps of the macro defining the macro functionality. Uses objects, properties, methods, and variables. |
|
|
Term
|
Definition
| Element of the Excel Application (such as a worksheet, a cell, or the entire workbook). See Help item "Application Object" for hierarchy of objects. See Help below for exact instructions on navigating to this item. In basic form, Visual Basic code is either written as object.property or object.method. For example, in the command Range("A3").Select, the object is Range("A3"), with Range("A3") meaning Cell A3. |
|
|
Term
|
Definition
"An attribute of an object that defines one of its characteristics (such as its name, size, color, formula, or location). All objects have properties. See ""properties"" help on each object help screen. Commands that change the properties of objects have the following general syntax:
object.property = expression For example, in the command Range(""A3"").Font.ColorIndex=3, Font.ColorIndex=3 is a property, changing the font in Cell A3 to red." |
|
|
Term
|
Definition
"An action that can be performed on an object (such as clearcontents, copy, delete, select, save, close). See ""methods"" help on each object help screen. Another command to change objects. The following is the general syntax:
object.method(parameter values) Parameter values are optional. For example, in the command Range(""A3"").Select, the method is Select, indicating that Excel should select Cell A3. " |
|
|
Term
|
Definition
"Name storage location containing data that you can retrieve and modify while the program is running. Variables are created and defined within the macro. Once you create a variable and give it a value, you can assign the value to an object. Command syntax:
variable = expression" |
|
|
Term
|
Definition
| Function key that will retrieve help when pressed while an object, property, or method is highlighted. |
|
|
Term
|
Definition
| Visual Basic Help for Excel applications is a separate help from the normal Excel help. You must be in Visual Basic Editor. Click on Help. Click on Contents, and then select "Microsoft Excel Visual Basic Reference". Double-click on the shortcut that appears. The Help screen should have "Excel" in the title bar. Go to index and type "application object" and then display. Click on an object to see objects below it in the hierarchy. Click on properties or methods to see those applicable to this object. |
|
|
