VBA FOR MODELERS, 3e, International Edition helps students gain valuable experience in automating simple but repetitive spreadsheet tasks, as well as developing decision support systems for complex management science models.
Part 1 VBA Fundamentals
- Introduction to VBA Development in Excel
- The Excel Object Model
- The Visual Basic Editor
- Recording Macros
- Getting Started with VBA
etc.
Part 2 VBA Management Science Applications
- Basic Ideas for Application Development with VBA
- A Blending Application
- A Product Mix Application
- An Employee-Scheduling Application
- A Production-Planning Application
etc.