List of Inside Out

---

Microsoft Office Excel 2003 Programming Inside Out

Inside Out
This statement illustrates an example of an
'Inside Out' problem statement

Chapter 2: Exploring Excel

Inside Out

Inside Out

Chapter 3: Exploring Visual Basic for Applications

Inside Out
Digital Certificates: You Can Even Create Your Own

Chapter 4: VBA Programming Starter Kit

Inside Out
Avoiding Errors Through Declarations

Inside Out

Chapter 5: Creating Sub and Function Procedures

Inside Out
The Pitfalls of Case Statements and Conditional Formats

Inside Out
The Good News Is That You Didn't Break It…

Inside Out
Recursion and Public Use: Two Procedural Pitfalls

Inside Out
Protecting Your Original Cell Data

Chapter 6: The Application Object

Inside Out
Pausing a Macro

Inside Out
Limiting the Calculations

Inside Out
The FormulaLocal Property and Local Settings

Chapter 7: Workbooks and Worksheets

Inside Out
When Is an Error Not an Error?

Inside Out
Creating Passwords That Will Stand the Test of Time

Chapter 8: Ranges and Cells

Inside Out
How Excel Extends a Range

Inside Out
Staying Away from Select

Inside Out
Measuring the Dimensions of a Cell

Inside Out
Naming Ranges

Inside Out
Names as Formulas

Chapter 9: Manipulating Data with VBA

Inside Out
Is a Function Built into VBA or Not?

Inside Out
When to Validate, and When to Use an If…Then Statement

Inside Out
Text Processing and Browser Cookies

Inside Out
Working with Times That Exceed 24 Hours

Chapter 12: Understanding and Using Events

Inside Out
The Quirky Change Event

Inside Out
Locate Events Using the Object Browser

Chapter 13: Manipulating Files

Inside Out
Determining if a File Exists Using FileSearch

Inside Out
Determining if a File Exists Using FileDialog

Inside Out
Opening a Text File

Chapter 15: Charts

Inside Out
The Recorded Macro and Creating Charts

Inside Out
To Use or Not to Use Chart Events

Inside Out
How the Chart SERIES Formula Works

Chapter 16: PivotTables and PivotCharts

Inside Out
An Interesting Occurrence

Chapter 18: Customizing Dialog Boxes

Inside Out
Return Variables or Execute?

Chapter 19: Creating User Forms

Inside Out
Built-in vs. Custom Dialog

Chapter 21: Excel and Other Office Applications

Inside Out
Simulate a Pause in VBA code

Inside Out
Early Binding vs. Late Binding

Inside Out
GetObject vs. CreateObject

Chapter 22: Excel and the Structured Query Language

Inside Out
Database Design and Administration

Chapter 23: Introducing ADO

Inside Out
Stored Procedures

Chapter 25: Excel and the Web

Inside Out
Web Page Style and Publication

Inside Out
That Was Table Number 2?

Chapter 26: Excel and the Extensible Markup Language (XML)

Inside Out
A Better Way to Create Lists

Inside Out
Watch Your Language

Inside Out
Mapping a Schema to a Single List

---