Table of Contents

• 1 If You’ve Never Programmed Before
• 2 Overview of VBA for Excel
• 3 Recording Macros
• 4 Customized Worksheet Functions
• 5 Modular Programming
• 6 Object-oriented Programming
• 7 Debugging and Testing
• 8 Data Typing And Variable Scope
• 9 Computations
• 10 Strings and Dialog Boxes
• 11 Structured Programming: Decisions
• 12 Structured Programming: Loops
• 13 Data Structures: Arrays and Records
• 14 Creating and Accessing Files
• 15 Custom Dialogue Boxes
• References
• Index

About the Author

Steven C. Chapra presently holds the Louis Berger Chair for Computing and Engineering in the Civil and Environmental Engineering Department at Tufts University. Dr. Chapra received engineering degrees from Manhattan College and the University of Michigan. Before joining the faculty at Tufts, he taught at Texas A&M University, the University of Colorado, and Imperial College, London. His research interests focus on surface water-quality modeling and advanced computer applications in environmental engineering. He has published over 50 refereed journal articles, 20 software packages and 6 books. He has received a number of awards including the 1987 ASEE Merriam/Wiley Distinguished Author Award, the 1993 Rudolph Hering Medal, and teaching awards from Texas A&M, the University of Colorado, and the Association of Environmental Engineering and Science Professors.