VBA/Excel for Engineers (Trade Version)

1. If You've Never Programmed Before.


The “Idea” of a Program. The Concept of Assignment. Decisions and Loops.



2. Overview of VBA for Excel.


The Excel/VBA Environment. An Excel Interface and a VBA Macro Program. Other Ways to Obtain and Display Information.



3. Recording Macros.


Macro Recording. Absolute and Relative References. Using Macro Recording to Learn about VBA. What Keyboard Macros Can't Do.



4. Customized Worksheet Functions.


The “Idea” of a Function. Worksheet Function Macros.



5. Modular Programming.


Sub Procedures. Function Procedures.



6. Object-Oriented Programming.


Objects, Properties, Methods and Collections. Using OOP for Input/Output. Learning More about OOP.



7. Debugging and Testing.


Debugging. The VBA Help Facility. Built-in Debugging Capabilities. Testing.



8. Data Typing and Variable Scope.


Data Types. Type Declaration. Variable Scope and Lifetime.



9. Computations.


Computation Rules. Built-in Numeric Functions.



10. Strings and Built-in Dialog Boxes.


String Functions and Manipulations. Message Boxes. Input Boxes.



11. Custom Dialogue Boxes.


A Simple Custom Dialogue Box. Custom Dialogue Boxes and Modules.



12. Structured Programming: Decisions.


Structured Programming. Flowcharts. The If/Then/Else Decision Structure. If/Then/Elseif Structure. Select Case Structure. Nesting. Compound Logical Expressions.



13. Structured Programming: Loops.


Decision Loops (Do/If Exit). Count-Controlled Loops. Nesting of Loops and Decisions. Recursion.



14. Data Structures: Arrays and Records.


Arrays. Records.



15. Creating and Accessing Files.


The Fundamentals. Other File Operations.



16. Numerical Methods in VBA.


Accessing Excel's Built-in Numerical Capabilities, as Well as Learning to Write Custom Macros to Implement Common Numerical Methods. Roots of Equations. Linear Algebraic Equations. Integration and Differentiation. Differential Equations.



17. Linking with Other Resources.


Linking with Other Languages. Linking with Libraries.



Appendices.


Overview of Excel. Built-in Excel and VBA Functions.