Table of Contents

 

Excel VBA Macro Programming
by Richard Shepherd	ISBN:0072231440
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 into Comments
	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
	Chapter 34	-	Summing Cells by Reference to a Master Cell
	Chapter 35	-	Globally Changing a Range of Values
	Chapter 36	-	Displaying Hidden Sheets Without a Password
	Chapter 37	-	Searching Multiple Sheets and Workbooks
	Chapter 38	-	Brighten Up Your Comments
	Chapter 39	-	An Alternative to Message Boxes
	Chapter 40	-	Working with Shapes
	Chapter 41	-	Turning Your VBA Code into an Add-In
	Appendix A	-	ASCII Character Codes
	Index
	List of Figures
	List of Tables