Contents -- Introduction -- Chapter 1 VISUAL BASIC FOR APPLICATIONS WITH EXCEL -- Project: Colorful Stats -- Installing and Enabling VBA -- The VBA Integrated Development Environment (IDE) -- Getting to the IDE from Excel -- Components of the IDE -- Programming Components within Excel -- Macro Selection -- The Visual Basic Toolbar -- Getting Help with VBA -- VBA Help -- Constructing the Colorful Stats Program -- Requirements of the Colorful Stats Program -- Chapter Summary -- Chapter 2 BEGINNING PROGRAMS WITH VBA -- Project: Biorhythms and the Time of Your Life -- Variables, Data Types, and Constants -- Declaring Variables -- Data Types -- Constants -- Simple Input and Output with VBA -- Collecting User Input with InputBox() -- Output with MsgBox() -- Manipulating Strings with VBA Functions -- Fun with Strings -- Constructing the Biorhythms and the Time of Your Life Program -- Requirements for Biorhythms and the Time of Your Life -- Designing Biorhythms and the Time of Your Life -- Coding Biorhythms and the Time of Your Life -- Chapter Summary -- Chapter 3 PROCEDURES AND CONDITIONS -- Project: Poker Dice -- VBA Procedures -- Event Procedures -- Private, Public, and Procedure Scope -- Sub Procedures -- Function Procedures -- Logical Operators with VBA -- Conditionals and Branching -- Constructing the Poker Dice Program -- Requirements for Poker Dice -- Designing Poker Dice -- Coding Poker Dice -- Chapter Summary -- Chapter 4 LOOPS AND ARRAYS -- Project: Math Game -- Looping with VBA -- Do Loops -- For Loops -- Input Validation -- Validation with the InputBox() Function -- Validation with a Spreadsheet Cell -- Arrays -- One-Dimensional Arrays -- Multi-Dimensional Arrays -- Dynamic Arrays -- Programming Formulas into Worksheet Cells -- A1 Style References -- R1C1-Style References -- Constructing the Math Game -- Requirements for the Math Game.

Designing the Math Game -- Coding the Math Game Program -- Chapter Summary -- Chapter 5 BASIC EXCEL OBJECTS -- Project: Battlecell -- VBA and Object-Oriented Programming -- Objects Defined -- VBA Collection Objects -- The Object Browser -- Top-Level Excel Objects -- The Application Object -- The Workbook and Window Objects -- The Worksheet Object -- The Range Object -- Working with Objects -- Constructing Battlecell -- Requirements for Battlecell -- Designing Battlecell -- Coding Battlecell -- Chapter Summary -- Chapter 6 VBA USERFORMS AND ADDITIONAL CONTROLS -- Project: Blackjack -- Designing Forms with VBA -- Adding a Form to a Project -- Components of the UserForm Object -- Adding ActiveX Controls to a Form -- Showing and Hiding Forms -- Modal Forms -- Designing Custom Dialog Boxes Using Forms -- Derived Data Types in VBA -- Defining Custom Data Types in VBA -- Defining Enumerated Types in VBA -- Chapter Project: Blackjack -- Requirements for Blackjack -- Designing Blackjack -- Writing the Code for Blackjack -- Chapter Summary -- Chapter 7 ERROR HANDLING DEBUGGING, AND BASIC FILE I/O -- Project: Word Find -- Error Handling -- Using the On Error Statement -- Debugging -- Break Mode -- The Immediate Window -- The Watch Window -- The Locals Window -- File Input and Output (I/O) -- File I/O Using Workbook and Worksheet Objects -- Using VBA File I/O Methods -- Chapter Project: Word Find -- Requirements for Word Find -- Designing Word Find -- Writing the Code for Word Find -- Chapter Summary -- Chapter 8 USING XML WITH EXCEL-VBA PROJECTS -- Project: Revisiting the Math Game -- Introduction to XML -- What Is XML? -- XML Syntax -- XML Schemas -- XML Validation -- XML and Excel -- XML and VBA -- The XmlMap Object -- Chapter Project: The Math Game -- Requirements for the Math Game Program -- Designing the Math Game -- Coding the Math Game Program.

Chapter Summary -- Chapter 9 EXCEL CHARTS -- Project: The Alienated Game -- The Chart Object -- Accessing Existing Charts -- Manipulating Charts -- Creating Charts -- Chart Events -- Chapter Project: The Alienated Game -- Requirements for the Alienated Game -- Designing the Alienated Game -- Coding the Alienated Game -- Chapter Summary -- Chapter 10 VBA SHAPES -- Project: Excetris -- The Shapes Collection and Shape Objects -- Manipulating a Shape Object -- The ShapeRange Collection Object -- Activating Shape Objects -- The OLEObjects Collection -- Chapter Project: Excetris -- Requirements for Excetris -- Designing Excetris -- Coding Excetris -- Chapter Summary -- A Final Word -- INDEX -- A -- B -- C -- D -- E -- F -- G -- H -- I -- J -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- X -- Y -- Z.