Liengme B.V. Excel VBA for Physicists: A primer

IOP Publishing, Morgan & Claypool Publishers, 2016. — 92 p. — (IOP concise physics). — ISBN 9781681744636.This work will introduce the reader to Visual Basic for Applications (VBA) and demonstrate how it can greatly enhance Microsoft Excel by giving users the ability to make their own functions that can be used within a worksheet, and to create subroutines to perform repetitive actions.
Visual Basic (VB, the parent of VBA) has its roots in the educational programming language BASIC redeveloped at Dartmouth College in 1964. In the half-century since then, the language has evolved to become a high-powered object-orientated language which is no longer denigrated by aficionados of language such as C++ and C#. The VBA compiler and editor is incorporated within the Excel application; there is nothing to buy or install.Variables, Dim statements, and data types
Structured programming
Some further examples
Working with add-ins
Numerical integration
Numerical methods for differential equations
Finding roots