VBA/Excel for Engineers (Trade Version)

VBA/Excel for Engineers (Trade Version)

  • Paperback
By (author) 

List price: US$23.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

For professionals and students interested in learning how to use VBA/Excel for engineering and scientific problem solving.This brief book shows students how to use Excel's VBA Programming functions for engineering and science problems, and how to create simple GUIs that perform calculations and display numerical and graphical results.show more

Product details

  • Paperback | 350 pages
  • 178 x 235mm
  • Pearson Education (US)
  • Pearson
  • United States
  • 0130473839
  • 9780130473837

Table of contents

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.show more