Excel Scientific and Engineering Cookbook > Getting Acquainted with Visual Basic for Applications - Pg. : Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Excel Scientific and Engineering Cookbook

Excel Scientific and Engineering Cookbook

Search

Contents

Ch. 1. Using Excel

Ch. 2. Getting Acquainted with Visual Basic for Applications

Recipe 2.1. Navigating the VBA Editor

Recipe 2.2. Writing Functions and Subroutines

Recipe 2.3. Working with Data Types

Recipe 2.4. Defining Variables

Recipe 2.5. Defining Constants

Recipe 2.6. Using Arrays

Recipe 2.7. Commenting Code

Recipe 2.8. Spanning Long Statements over Multiple Lines

Recipe 2.9. Using Conditional Statements

Recipe 2.10. Using Loops

Recipe 2.11. Debugging VBA Code

Recipe 2.12. Exploring VBA's Built-in Functions

Recipe 2.13. Exploring Excel Objects

Recipe 2.14. Creating Your Own Objects in VBA

Recipe 2.15. VBA Help

Ch. 3. Collecting and Cleaning Up Data

Ch. 4. Charting

Ch. 5. Statistical Analysis

Ch. 6. Time Series Analysis

Ch. 7. Mathematical Functions

Ch. 8. Curve Fitting and Regression

Ch. 9. Solving Equations

Ch. 10. Numerical Integration and Differentiation

Ch. 11. Solving Ordinary Differential Equations

Ch. 12. Solving Partial Differential Equations

Ch. 13. Performing Optimization Analyses in Excel

Ch. 14. Introduction to Financial Calculations

URL

Help

Chapter 2. Getting Acquainted with Visual Basic for Applications

Navigating the VBA Editor

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial