VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel

by S. Christian Albright

Help your students master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office, with this essential tool. Chris Albright's VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E provides everything you need to teach students how to automate common spreadsheet tasks as well as create the sophisticated management science applications needed in business today. The first half of the book introduces students to the fundamentals of VBA for Excel. The second half puts knowledge into action as it illustrates how to automate a number of management science models using VBA. Students learn how to use applications to present a user-friendly interface for inputs and results. This new edition improves code readability, introduces PowerPivot and the Excel Data Model and demonstrates a new method to pass information between modules and user forms that avoids using global variables.

736 pages, Paperback

First published December 12, 2000

Reviews

[Sonya · Rating 3 out of 5]

Painful read... but very thorough. I must say I got my foot in the VBA door with this book.

[Rishika Gupta · Rating 5 out of 5]

It is a highly useful book for learning how to automate, analyse, and build powerful models in Excel using Visual Basic for Applications. It helps readers understand programming logic through practical business and financial modelling examples. The book is especially valuable for students, analysts, and professionals who want to enhance efficiency and create complex solutions. It’s a strong foundation for anyone looking to master modelling with VBA.

[Rick · Rating 5 out of 5]

Perfect for learning VBA even if you have never programmed before.
I've been teaching an intro VBA course with the Albright's book since third edition I think. While I describe it as being written by a business guy who likes to code and not a programmer who likes business, it stands above similar books because it has exercises in every chapter.