Introduction to VBA for Excel
by Steven C. Chapra
For introductory courses in Engineering and Computer Science.
Teach your students to program and design user interfaces using Excel 2007.
Introduction to VBA for Excel, 2e is an introductory text that is designed to instruct engineering and science students on how to develop programs using VBA within the Microsoft Excel environment. It is written for students at all levels and does not assume any previous programming experience.
The new edition has been revised to bring it up-to-date with the Office 2007 environment.
Writing Excel Macros with VBA
by Steven Roman, Steven PhD
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:
- The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros.
The VBA programming language, the same programming language used by the other applications in Microsoft Office XP and 2000, as well as by the retail editions of Visual Basic 6.0. The Excel object model, including new objects and new members of existing objects in Excel 2002. Excel exposes nearly all of its functionality through its object model, which is the means by which Excel can be controlled programmatically using VBA. While the Excel object model, with 192 objects, is the second largest among the Office applications, you need to be familiar with only a handful of objects to write effective macros. Writing Excel Macros focuses on these essential objects, but includes a discussion of many more objects as well.
Writing Excel Macros with VBA, 2nd Edition is written in a terse, no-nonsense manner that is characteristic of Steven Roman’s straightforward, practical approach. Instead of a slow-paced tutorial with a lot of handholding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This tutorial is reinforced by interesting and useful examples that solve common problems you’re sure to have encountered.
Writing Excel Macros with VBA, 2nd Edition is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity.
Excel VBA Programming For Dummies
by John Walkenbach
In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you’ll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program flow, and much more.
With the release of Microsoft Office 2016, Excel will see changes in its operating system, and this fun, hands-on guide will make it easier than ever to harness the power of Visual Basic for Applications and create custom applications and macros on the world’s most popular spreadsheet tool. Packed with friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, you’ll be creating Excel applications custom-fit to your unique needs in no time at all!
- Provides step-by-step instructions for creating VBA macros to maximize productivity
- Helps to increase efficiency by demonstrating how to customize your applications so they look and work the way you want
- Fully updated for Excel 2016
- All sample programs, VBA code, and worksheets are available at dummies.com
If you’re a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4th Edition makes it easier.
Credit Risk Modeling Using Excel and VBA
by Gunter Löeffler, Mr Peter N Posch
This book provides practitioners and students with an intuitive, hands-on introduction to modern credit risk modelling. Every chapter starts with an explanation of the methodology and then the authors take the reader step by step through the implementation of the methods in Excel and VBA. They focus specifically on risk management issues and cover default probability estimation (scoring, structural models, and transition matrices), correlation and portfolio analysis, validation, as well as credit default swaps and structured finance.
The book has an accompanying website, http://loeffler-posch.com/, which has been specially updated for this Second Edition and contains slides and exercises for lecturers.