| |
| |
| |
| If You've Never Programmed Before | |
| |
| |
| The Idea of a Program | |
| |
| |
| The Concept of Assignment | |
| |
| |
| Decisions and Loops | |
| |
| |
| A Simple Example | |
| |
| |
| |
| Overview of VBA for Excel | |
| |
| |
| The Excel/VBA Environment | |
| |
| |
| An Excel Interface and a VBA Macro Program | |
| |
| |
| Other Ways to Obtain and Display Information | |
| |
| |
| |
| Recording Macros | |
| |
| |
| Macro Recording | |
| |
| |
| Absolute and Relative References | |
| |
| |
| Using Macro Recording to Learn about VBA | |
| |
| |
| What Keyboard Macros Can't Do | |
| |
| |
| |
| Customized Worksheet Functions | |
| |
| |
| The Idea of a Function | |
| |
| |
| Worksheet Function Macros | |
| |
| |
| |
| Modular Programming | |
| |
| |
| Sub Procedures | |
| |
| |
| Function Procedures | |
| |
| |
| More about Procedure Arguments | |
| |
| |
| Passing by Value or by Reference | |
| |
| |
| Static Variables | |
| |
| |
| |
| Object-Oriented Programming | |
| |
| |
| Objects, Properties, Methods, and Collections | |
| |
| |
| Using Oop for Input/Output | |
| |
| |
| Learning More about Oop | |
| |
| |
| |
| Debugging and Testing | |
| |
| |
| Debugging | |
| |
| |
| The VBA Help Facility | |
| |
| |
| Built-in Debugging Capabilities | |
| |
| |
| Testing | |
| |
| |
| |
| Data Typing and Variable Scope | |
| |
| |
| Data Types | |
| |
| |
| Type Declaration | |
| |
| |
| Variable Scope and Lifetime | |
| |
| |
| |
| Computations | |
| |
| |
| Computations | |
| |
| |
| Built-in Numeric Functions | |
| |
| |
| |
| Strings and Dialog Boxes | |
| |
| |
| String Functions and Manipulations | |
| |
| |
| Message Boxes | |
| |
| |
| Input Boxes | |
| |
| |
| |
| Structured Programming: Decisions | |
| |
| |
| Structured Programming | |
| |
| |
| Flowcharts | |
| |
| |
| The If/Then/Else Decision Structure | |
| |
| |
| The If/Then/Elseif Structure | |
| |
| |
| Selected Case Structure | |
| |
| |
| Nesting | |
| |
| |
| Compound Logical Expressions | |
| |
| |
| |
| Structured Programming: Lops | |
| |
| |
| Decision Loops (Do/if Exit) | |
| |
| |
| Count-Controlled Loops | |
| |
| |
| Nesting of Loops and Decisions | |
| |
| |
| Recursion | |
| |
| |
| |
| Data Structures: Arrays and Records | |
| |
| |
| Arrays | |
| |
| |
| Records | |
| |
| |
| |
| Creating and Accessing Files | |
| |
| |
| Sequential Files | |
| |
| |
| Other File Operations | |
| |
| |
| |
| Custom Dialogue Boxes | |
| |
| |
| A Simple Custom Dialogue Box | |
| |
| |
| Custom Dialogue Boxes and Modules | |