Chapter 4 looks at Excel 2007 UserForms and the tools they provide. Its examples show
how to build simple and complex data entry forms, and how to use classes to add functionality
to the UserForms.
Chapter 5 explores charting in Excel 2007. After examining the code created by the Macro
Recorder, it shows how to use the Chart object in code.
Chapter 6 takes a look at Excel PivotTable reports. PivotTables are powerful data analysis
tools, and they??™re easy to create and modify. The code samples show how to create and modify
PivotTable reports.
Chapter 7 is an overview of VBA debugging tools and techniques. The Immediate, Locals,
and Watch windows are shown in detail. The section on error handling shows how to effectively
trap for errors and how to provide positive feedback to the user.
Chapter 8 is all about integrating your Excel solution with other Microsoft Office applications.
Its examples include building a chart report in Word 2007 and building a PowerPoint
presentation that includes text and charts from an Excel workbook.
Chapter 9 shows how to use components built in Visual Basic 6 and Visual Studio 2005 in
your Excel 2007 projects. Examples from earlier chapters are re-created using ActiveX technologies
in Visual Basic 6 and .NET assemblies using Visual Studio 2005 and Visual Studio
Tools for Office 2005.
Prerequisites
Microsoft Excel 2007 is required for the examples in this book. For Chapter 8, ???Office Integration,???
you??™ll need Microsoft Word 2007 and PowerPoint 2007.
Pages:
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29