Programming in Excel 2007 and 2010

Like all previous versions of Excel, the latest version of Excel 2010 comes with the Visual Basic for Application editor and developer tools. This allows you not only to create macros using the record, but also to develop your own programs and functions by directly writing code in VBA. The VBA editor also lets you use custom dialog boxes, add custom controls to the Excel workbook, and create new custom add-ins.

This book assumes no prior knowledge of programming and you will learn how to create macros in Excel 2010 from the very beginning. Creating your own programming code in conjunction with user dialogs allows you to greatly expand the capabilities of Excel 2010, not only for your own use, but for a wider range of users.