Introduction to VBA for Excel

by Chapra, Steven C.

• ISBN13: 9780132396677
• ISBN10: 013239667X
• Edition: 2nd
• Format: Paperback
• Copyright: 2009-06-29
• Publisher: Pearson

Summary

Part of Esource--Prentice Hall's Engineering Source, this book provides a flexible introduction to the use of VBA/Excel in engineering. Featuring over 25 modules and growing, the ESource series provides a comprehensive resource of essential engineering topics. Covers topics such as an introduction to programming, recording macros, customized worksheet functions, modular and object-oriented programming, strings and dialog boxes, and data structures. For any Engineer or Computer Scientist interested in a brief introduction to VBA/Excel.

Author Biography

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.

Table of Contents

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

Table of Contents provided by Publisher. All Rights Reserved.