eBook - Excel VBA Macro Programming.pdf

Excel VBA Macro Programming
by Richard Shepherd ISB
N:0
072
231
440
McGraw-Hill/Osborne © 2004 (319 pages)
This unique book presents sample
code for more than twenty practical,
high-powered Excel VBA macro
applications. You get all the essentials
of VBA, then explore ways to power
Excel with VBA.
Table of Contents
Excel VBA Macro Programming
Introduction
Part I - Programming in Excel VBA
Chapter 1 - The Basics
Variables, Arrays, Constants, and Data
Chapter 2 -
Types
Chapter 3 - Modules, Functions, and Subroutines
Chapter 4 - Programming Basics: Decisions and Looping
Chapter 5 - Strings and Functions and Message Boxes
Chapter 6 - Operators
Chapter 7 - Debugging
Chapter 8 - Errors and the Error Function
Chapter 9 - Dialogs
Chapter 10 - Common Dialog Control
Chapter 11 - Command Bars and Buttons
Part II - Object Models
Chapter 12 - The Excel Object Model
Chapter 13 - The Excel Object Model-Main Objects
Using Excel to Interact with Other Office
Chapter 14 -
Programs
Part III - Advanced Techniques in Excel VBA
Chapter 15 - Charts and Graphs
Chapter 16 - Working with Databases
Chapter 17 - API Calls
Chapter 18 - Class Modules
Chapter 19 - Animation
Part IV - VBA in Action
Converting Labels to Numbers and Numbers
Chapter 20 -
to Labels
Chapter 21 - Transposing a Range of Cells
Chapter 22 - Adding Formula Details ments
Chapter 23 - Calculating a Range
Chapter 24 - Reversing a Label
Chapter 25 - Who Created the Workbook?
Chapter 26 - Evaluating a Cell
Chapter 27 - Sorting Worksheets into Alphabetical Order
Chapter 28 - Replacing Characters in a String
Chapter 29 - Timed Events
Chapter 30 - Auto Totaling a Matrix of Numbers
Chapter 31 - Absolute and Relative Formulas
Coloring Alternate Rows and Columns of
Chapter 32 -
the Spreadsheet
Chapter 33 - Coloring Cells Containing Formulas
Summing Cells by Reference to a Master Cel
Chapter 34 -
l
Chapter 35 - Globally C