CART

(0) items

Introduction to VBA for Excel

by
Edition:
2nd
ISBN13:

9780132396677

ISBN10:
013239667X
Format:
Paperback
Pub. Date:
6/29/2009
Publisher(s):
Prentice Hall
List Price: $59.20

Rent Textbook

(Recommended)
 
Term
Due
Price
$29.60

Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours
N9780132396677
$57.24

eTextbook


 
Duration
Price
$28.79

Used Textbook

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $48.23
See Prices

Questions About This Book?

Why should I rent this book?
Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.
How do rental returns work?
Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!
What version or edition is this?
This is the 2nd edition with a publication date of 6/29/2009.
What is included with this book?
  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.

Related Products


  • Power Programming with VBA/Excel
    Power Programming with VBA/Excel




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.


Please wait while the item is added to your cart...