Introduction to VBA for Excel

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780132396677 | 013239667X
Cover: Paperback
Copyright: 6/29/2009

Rent

(Recommended)

$39.13

Term

Due

Price

Semester

Dec 16

$41.19

Quarter

Aug 12

$39.13

Short Term

Jul 21

$37.07

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.
Buy Used

Usually Ships in 2-4 Business Days

$48.99
Buy New

Currently Available, Usually Ships in 24-48 Hours

$65.66

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.

You might also enjoy...

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

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.

FREE SHIPPING

Introduction to VBA for Excel

Rent

Buy Used

Buy New

Summary

Author Biography

Table of Contents

You might also enjoy...