文档介绍：ABC Amber CHM Converter Trial version,
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
Chapter 2 - Variables, Arrays, Constants, and Data 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
Chapter 14 - Using Excel to Interact with Other Office 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
Chapter 20 - Converting Labels to Numbers and Numbers 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
Chapter 32 - Coloring Alternate Rows and Columns of the Spreadsheet
Chapter 33 - Coloring Cells Containing Formulas
ABC Amber CHM Converter Trial version, chm