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.

1. Introduction to VBA Development in Excel.
2. The Excel Object Model.
3. The Visual Basic Editor.
4. Recording Macros.
5. Getting Started with VBA.
6. Working with Ranges.
7. Control Logic and Loops.
8. Working with Other Excel Objects.
9. Arrays.
10. More on Variables and Subroutines.
11. User Forms
12. Error Handling.
13. Working with Files and Folders.
14. Importing Data into Excel from a Database.
15. Working with Pivot Tables and Tables.
16. Working with Ribbons, Menus, and Toolbars.
17. Automating Solver and Other Applications.
18. User-Defined Types, Enumerations, Collections, and Classes.
Part II: VBA MANAGEMENT SCIENCE APPLICATIONS.
19. Basic Ideas for Application Development with VBA.
20. A Blending Application.
21. A Product Mix Application.
22. A Worker Scheduling Application.
23. A Production Planning Application.
24. A Transportation Application.
25. A Stock Trading Simulation Application.
26. A Capital Budgeting Application.
27. A Regression Application.
28. An Exponential Utility Application.
29. A Queuing Simulation Application.
30. An Option Pricing Application.
31. An Application for Finding Betas of Stocks.
32. A Portfolio Optimization Application.
33. A Data Envelopment Analysis Application.
34. An AHP Application for Choosing a Job (web chapter)
35. A Poker Simulation Application. (web chapter)

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. NEW METHOD FOR PASSING INFORMATION BETWEEN MODULES AND USER FORMS. This new method avoids the use of global variables, making it easier for students to follow and understand. NEW BRIEF SECTION ON POWERPIVOT AND THE EXCEL DATA MODEL. Students become familiar with this new approach for integrating data from multiple tables and building a relational data source inside an Excel workbook. STUDENTS GAIN SUCCESS IN SIMPLE AUTOMATIONS BEFORE TACKLING MORE COMPLEX CHALLENGES. Students begin with simple macros for automating common spreadsheet tasks before progressing to complete decision support systems. STUDENTS LEARN TO MAXIMIZE THE POTENTIAL CAPABILTIES OF VBA. The author effectively illustrates the power of VBA when coupled with management science models.