Excel® VBA for Physicists

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. Visual Basic (VB, the parent of VBA) has evolved to become a high-powered object-orientated language that is no longer denigrated by aficionados of language such as C++ and C#. The text is suitable not just for physicists but for other scientists and engineers, including students.

Key features

Includes supplementary Excel worksheets