VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel, 5th Edition

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.

Table of Contents

Part I: VBA Fundamentals
Ch 1: Introduction to VBA Development in Excel
Ch 2: The Excel Object Model
Ch 3: The Visual Basic Editor
Ch 4: Recording Macros
Ch 5: Getting Started with VBA
Ch 6: Working with Ranges
Ch 7: Control Logic and Loops
Ch 8: Working with Other Excel Objects
Ch 9: Arrays
Ch 10: More on Variables and Subroutines
Ch 11: User Forms
Ch 12: Error Handling
Ch 13: Working with Files and Folders
Ch 14: Importing Data into Excel from a Database
Ch 15: Working with Pivot Tables and Tables
Ch 16: Working with Ribbons, Toolbars, and Menus
Ch 17: Automating Solver and Other Applications
Ch 18: User-Defined Types, Enumerations, Collections, and Classes

Part II: VBA Management Science Applications
Ch 19: Basic Ideas for Application Development with VBA
Ch 20: A Blending Application
Ch 21: A Product Mix Application
Ch 22: A Worker Scheduling Application
Ch 23: A Production-Planning Application
Ch 24: A Transportation Application
Ch 25: A Stock-Trading Simulation Application
Ch 26: A Capital Budgeting Application
Ch 27: A Regression Application
Ch 28: An Exponential Utility Application
Ch 29: A Queueing Simulation Application
Ch 30: An Option-Pricing Application
Ch 31: An Application for Finding Betas of Stocks
Ch 32: A Portfolio Optimization Application
Ch 33: A Data Envelopment Analysis Application
Ch 34: An AHP Application for Choosing a Job
Ch 35: A Poker Simulation Application