VBA Help


You'd like more information on Visual Basic for Applications.


Look in the VBA help guide. Select Help images/U2192.jpg border=0> Microsoft Visual Basic Help from the main menu bar. For context-sensitive help, you can select a keyword in a code window and press F1 to open up a new help window containing information specific to the selected keyword.

Further, if you'd like to learn more about programming Excel in general, I can recommend Steven Roman's book Writing Excel Macros with VBA (O'Reilly). Steven's book covers most of the topics summarized in this chapter. He also covers topics I've left out that, while useful for general Excel programming, aren't immediately relevant to the calculations I discuss in this book.

Using Excel

Getting Acquainted with Visual Basic for Applications

Collecting and Cleaning Up Data


Statistical Analysis

Time Series Analysis

Mathematical Functions

Curve Fitting and Regression

Solving Equations

Numerical Integration and Differentiation

Solving Ordinary Differential Equations

Solving Partial Differential Equations

Performing Optimization Analyses in Excel

Introduction to Financial Calculations


Excel Scientific and Engineering Cookbook
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors: David M Bourg

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net