| Argument | A symbolic name for a value, expression, or cell reference that is passed to the function for its use in calculating an answer.
|
 |
|
|
| Branching | A programming structure that evaluates a condition and then takes one of two actions based on the outcome of condition evaluation.
|
|
|
|
| Data type | The type of information that is stored in a variable.
|
|
|
|
| Event procedure | A procedure that executes whenever a particular event occurs.
|
|
|
|
| Form | A dialog box that appears in response to a user-defined command key click or other event.
|
|
|
|
| Iteration | See repetition.
|
|
|
|
| Looping | See repetition.
|
|
|
|
| Macro | See macro instruction.
|
|
|
|
| Macro instruction | A group of VBA statements that collectively performs a particular task or returns a result.
|
|
|
|
| Method | An action that takes place on behalf of the object to which it is attached.
|
|
|
|
| Module | An Excel object where macros are saved.
|
|
|
|
| Personal Macro Workbook | A workbook that Excel always loads, and subsequently hides, whenever you launch Excel.
|
|
|
|
| Project | Contains forms, modules, and the Excel workbook objects.
|
|
|
|
| Prototype statement | The first line of the function definition.
|
|
|
|
| Repetition | A programming structure that repeats a series of steps until a special condition is recognized to halt the repetition.
|
|
|
|
| Selection | See branching.
|
|
|
|
| UDF | See user-defined function.
|
|
|
|
| User-defined function | A function you create.
|
|
|
|
| VBA function | A procedure that returns a result just as do Excel's built-in functions such as SUM and PMT.
|
|
|
|
| VBA procedure | See macro instruction.
|
|
|
|
| VBA subroutine | A VBA procedure that performs a particular task.
|
|
|
|
| Workbook objects | A workbook's worksheets and chart sheets.
|