Introduction to VBA for Excel
ISBN: 9780132396677 | 013239667X
Edition: 2ndFormat: Paperback
Publisher: Prentice Hall
Pub. Date: 6/29/2009
Why Rent from Knetbooks?
Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!
Top 5 reasons to order all your textbooks from Knetbooks:
- We have the lowest prices on thousands of popular textbooks
- Free shipping both ways on ALL orders
- Most orders ship within 48 hours
- Need your book longer than expected? Extending your rental is simple
- Our customer support team is always here to help
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.
... MORE
... MORE
| 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 | |
| ... MORE | |
| 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. |
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.
Related Products
Power Programming with VBA/Excel
Please wait while this item is added to your cart...
