Excel® VBA for physicists
Subtitle: a primer
By: Bernard V. Liengme
Contributors: Morgan & Claypool Publishers; Institute of Physics (Great Britain)
Series: IOP concise physics; IOP concise physics
Publisher: Morgan & Claypool Publishers
Published: 2016
Place of publication: San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA)
Language: eng
ISBN-13: 9781681744612; 9781681744636; 9781681744605
Subjects: Physics; Data processing; Mathematical Physics; Applied Physics; SCIENCE; General; Mathematical & Computational; Visual Basic; Microsoft Excel (Computer file)
Other titles: Excel® Visual Basic for applications for physicists :
Description: This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel® by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel® workbooks are available for each chapter and there is nothing to buy or install.
Notes: "Version: 20161101"--Title page verso.

"A Morgan & Claypool publication as part of IOP Concise Physics"--Title page verso.

Title from PDF title page (viewed on December 7, 2016).

Includes bibliographical references.

Access restricted to Ryerson students, faculty and staff.

Suitable for physicists and other scientists and engineers, including students.

Bernard V. Liengme is a Retired Professor of Chemistry and Lecturer in Information Systems of St Francis Xavier University in Nova Scotia, Canada. He is the author of several Microsoft Excel® guides for business and scientists and engineers, and two other titles published with IOP ebooks. Bernard has been awarded the Microsoft Most Valued Professional award in Excel® in eight consecutive years.
Table of contents: title: Preface; title: 1. Introduction; title: 1.1. Preparation; title: 1.2. Demonstrating a simple function; title: 1.3. Saving a macro-enabled workbook; title: 1.4. Using constants and VB functions; title: 1.5. User-defined array function; title: 1.6. Notes on VBA functions; title: 1.7. A simple subroutine; title: 1.8. Linking an image to a subroutine; title: 1.9. Recording a macro; title: 1.10. Finding a home for macros; title: 1.11. Typographical matters.; title: 2. Variables, Dim statements, and data types; title: 2.1. Naming variables; title: 2.2. The Dim statement; title: 2.3. The major reason for variable declarations; title: 2.4. Declarations in function headers and for constants; title: 2.5. Data types; title: 2.6. A second reason for variable declarations; title: 2.7. Dimensioning arrays; title: 2.8. The Set statement; title: 2.9. The With ... End With structure.; title: 3. Structured programming; title: 3.1. Branching structures (If and Select Case); title: 3.2. Looping structures (For ... Next and Do ... While/Until); title: 3.3. Some further examples.; title: 4. The Excel object model; title: 4.1. Examples of properties, methods and events; title: 4.2. The Range object properties; title: 4.3. Range object methods; title: 4.4. WorksheetFunction object; title: 4.5. Workbook and worksheet events; title: 4.6. Code for sending email.; title: 5. Working with add-ins; title: 5.1. Creating an add-in; title: 5.2. Installation; title: 5.3. Using the add-in; title: 5.4. Making changes to the add-in; title: 5.5. Viewing worksheets; title: 5.6. Protecting the add-in; title: 5.7. Reversing everything.; title: 6. Numerical integration; title: 6.1. The trapezoid approximation; title: 6.2. The Simpson 1/3 approximation; title: 6.3. An aside; title: 6.4. Monte Carlo integration; title: 6.5. Gaussian and Romberg integration.; title: 7. Numerical methods for differential equations; title: 7.1. Euler's method; title: 7.2. The Runge-Kutta fourth-order method; title: 7.3. Simultaneous OEDs; title: 7.4. Example of a system of two OEDs; title: 7.5. Higher order OEDs; title: 7.6. R-L circuit.; title: 8. Finding roots; title: 8.1. The bisection method; title: 8.2. The successive iteration method; title: 8.3. Root finding with Solver; title: 8.4. Using range names.