Simon J. Excel Programming: Your visual blueprint for creating interactive spreadsheets

Jinjer Simon.
2002 Published by Hungry Minds, Inc.
909 Third Avenue New York, NY
10022..
Excel Programming: Your visual blueprint for creating.
interactive spreadsheets uses simple, straightforward.
examples to teach you how to create powerful and.
dynamic programs.
To get the most out of this book, you should read each.
chapter in order, from beginning to end. Each chapter.
introduces new ideas and builds on the knowledge.
learned in previous chapters. When you become familiar.
with Excel Programming: Your visual blueprint for creating.
interactive spreadsheets, you can use this book as an.
informative desktop reference.
An Introduction to the Excel Object Model.
Using the Object Browser.
Create an Object Variable.
Change the Properties of an Object.
Compare Object Variables.
Using an Object Method.
Display a Built-in Dialog Box.
Assign Values to Variables.
Using Global Variables.
Declare an Array.
Declare a Multidimensional Array.
Convert a List into an Array.
Redimension an Array.
Create a User-Defined Data Type.
Execute a Task While a Condition is True.
Perform Multiple Tasks Until a Condition is Met.
Execute Tasks a Specific Number of Times.
Using the For Each Next Loop.
Conditionally Execute a Group of Statements.
Execute a Statement Based Upon the Value.
Jump to a Specific Location in a Macro.
Conditionally Call a Subroutine.
Copy and Paste a Sheet.
Hide a Sheet.
Change the Name of a Sheet.
Save a Sheet to Another File.
Protect a Worksheet.
Protect a Chart.
Print a Sheet.
Sort Worksheets by Name.
Using the Range Property.
Using the Cells Property.
Combine Multiple Ranges.
Using the Offset Property.
Delete a Range of Cells.
Hide a Range of Cells.
Specify the Name of a Range.
Resize a Range.
Insert a Range.
Set the Width of Columns in a Range.
Set the Height of Rows in a Range.
Convert a Column of Text into Multiple Columns.
Find the Intersection of Two Ranges.
Cut and Paste Ranges of Cells.
Custom Paste Values in Cells.
Add Comments to a Cell.
Automatically Fill a Range of Cells.
Copy a Range to Multiple Sheets.
Place Borders Around a Range of Cells.
Find Specific Cell Values.
Find and Replace Values in Cells.
Understanding Excel Events.
Run a Procedure as a Workbook Opens.
Run a Procedure Before Closing a Workbook.
Run a Procedure Before Saving a Workbook.
Run a Procedure When Excel Creates a Workbook.
Monitor a Range of Cells for Changes.
Execute a Procedure at a Specific Time.
Execute a Procedure When You Press Keys.
Run a Procedure When Right-Clicking a Chart.
VBA and Excel Object Model Quick Reference.