ACKNOWLEDGMENTS -- ABOUT THE AUTHORS -- CONTENTS -- 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 -- Additional Development Tools -- Getting Help with VBA -- Constructing the Colorful Stats Program -- Requirements of the Colorful Stats Program -- Designing the Colorful Stats Program -- Coding the Colorful Stats Program -- Summary -- Challenges -- CHAPTER 2 BEGINNING PROGRAMMING WITH VBA -- Project: Biorhythms and the Time of Your Life -- Variables, Data Types, and Constants -- Declaring Variables -- Object and Standard Modules -- Variable Scope -- Data Types -- Numerical Data Types -- String Data Types -- Variant Data Types -- Boolean Data Types -- Date 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 -- Summary -- Challenges -- CHAPTER 3 PROCEDURES AND CONDITIONS -- Project: Poker Dice -- Event Procedures -- Parameters with Event Procedures -- Private, Public, and Procedure Scope -- Sub Procedures -- ByVal and ByRef -- Function Procedures -- Creating Your Own VBA Functions -- Using Excel Application Functions in VBA -- Logical Operators with VBA -- AND, OR, and NOT Operators -- Conditionals and Branching -- If/Then/Else -- Select/Case -- Constructing the Poker Dice Program -- Requirements for Poker Dice -- Designing Poker Dice -- Coding Poker Dice -- Summary -- Challenges.

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 -- Summary -- Challenges -- CHAPTER 5 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 -- Using the Cells Property -- Working with Objects -- The With/End With Structure -- The Object Data Type -- For/Each and Looping through a Range -- Constructing BattleCell -- Requirements for BattleCell -- Designing BattleCell -- Coding BattleCell -- Adding Sound to Your VBA Program -- Summary -- Challenges -- 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 -- The Option Button Control -- The Scroll Bar Control -- The Frame Control -- The RefEdit Control -- The MultiPage Control -- The List Box and Combo Box Controls -- A Custom Dialog for Quick Stats -- 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 -- Summary -- Challenges.

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 -- Opening and Saving Workbooks -- Using VBA File I/O Methods -- The FileDialog Object -- The FileDialogFilters and FileDialogSelectedItems Collection Objects -- The FileSystem Object -- The Open Statement -- Sequential Access Files -- Random Access Files -- Chapter Project: Word Find -- Requirements for Word Find -- Designing Word Find -- Writing the Code for Word Find -- Summary -- Challenges -- CHAPTER 8 USING XML WITH EXCEL VBA PROJECTS -- Project: Revisiting the Math Game -- Introduction to XML -- What Is XML? -- An XML Sample -- XML Documents Must Have a Root Element -- XML Elements Must Have a Closing Tag -- XML Tags Are Case-Sensitive -- XML Tags Must Be Properly Nested -- XML Attributes Must Be Enclosed in Quotation Marks -- XML Element Names -- XML Schemas -- XML Validation -- XML and Excel -- Opening and Importing XML Documents into an Excel Worksheet -- Saving Worksheets to XML Files -- Saving Data as an XML Spreadsheet -- Saving a Worksheet as XML Data -- XML and VBA -- Saving and Opening XML Documents -- The XmlMap Object -- The ListObject Object -- Chapter Project: The Math Game -- Requirements for the Math Game Program -- Designing the Math Game -- Coding the Math Game Program -- Summary -- Challenges -- CHAPTER 9 EXCEL CHARTS -- Project: The Alienated Game -- The Chart Object -- Accessing Existing Charts -- Chart Sheets -- Embedded Charts -- Manipulating Charts -- Creating Charts -- Creating a Chart Sheet -- Creating an Embedded Chart -- Chart Events -- Chart Sheets -- Chapter Project: The Alienated Game.

Requirements for the Alienated Game -- Designing the Alienated Game -- Coding the Alienated Game -- Summary -- Challenges -- CHAPTER 10 VBA SHAPES -- Project: Excetris -- The Shapes Collection and Shape Objects -- Manipulating a Shape Object -- Looping through a Collection of Shapes -- The Shaperange Collection Object -- Activating Shape Objects -- The OLEObjects Collection -- Chapter Project: Excetris -- Requirements for Excetris -- Designing Excetris -- Coding Excetris -- Summary -- Challenges -- APPENDIX A: COMMON CHARACTER CODES -- APPENDIX B: KEYBOARD SHORTCUTS FOR THE CODE WINDOW -- APPENDIX C: TRAPPABLE ERRORS -- APPENDIX D: VISUAL BASIC ENVIRONMENT OPTIONS -- INDEX -- A -- B -- C -- D -- E -- F -- G -- H -- I -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- X.