Part I | |
| | |
Chapter 1 | |
| | |
What Can You Do with VBA? | |
| | |
Inserting a bunch of text | |
| | |
Creating a custom button | |
| | |
VBA disadvantages | |
| | |
An Excursion into Versions | |
| | |
Chapter 2 | |
| | |
What Youll Be Doing | |
| | |
Recording the Macro | |
| | |
Testing the Macro | |
| | |
Modifying the Macro | |
| | |
Saving Workbooks that Contain Macros | |
| | |
More about the NameAndTime Macro | |
| | |
Part II | |
| | |
Chapter 3 | |
| | |
Understanding VBE components | |
| | |
Working with the Project Explorer | |
| | |
Adding a new VBA module | |
| | |
Removing a VBA module | |
| | |
Working with a Code Window | |
| | |
Creating a module | |
| | |
Entering code directly | |
| | |
Using the macro recorder | |
| | |
Copying VBA code | |
| | |
Using the Editor Format tab | |
| | |
Using the General tab | |
| | |
Chapter 4 | |
| | |
Climbing the Object Hierarchy | |
| | |
Wrapping Your Mind around Collections | |
| | |
Referring to Objects | |
| | |
Simplifying object references | |
| | |
Diving into Object Properties and Methods | |
| | |
Object methods | |
| | |
Object events | |
| | |
Using the Object Browser | |
| | |
Chapter 5 | |
| | |
Looking at Sub procedures | |
| | |
Naming Subs and Functions | |
| | |
Executing the Sub procedure directly | |
| | |
Executing the procedure from the Macro dialog box | |
| | |
Executing the procedure from a button or shape | |
| | |
Executing the procedure from another procedure | |
| | |
Executing Function procedures | |
| | |
Calling a function from a worksheet formula | |
| | |
Chapter 6 | |
| | |
Recording Basics | |
| | |
Preparing to Record | |
| | |
Relative or Absolute? | |
| | |
Recording in relative mode | |
| | |
What Gets Recorded? | |
| | |
Recording Options | |
| | |
Macro name | |
| | |
Store Macro In | |
| | |
Part III | |
| | |
Chapter 7 | |
| | |
Using Variables Constants and Data Types | |
| | |
What are VBAs data types? | |
| | |
Declaring and scoping variables | |
| | |
Working with constants | |
| | |
Working with strings | |
| | |
Working with dates | |
| | |
Using Assignment Statements | |
| | |
Other operators | |
| | |
Working with Arrays | |
| | |
Multidimensional arrays | |
| | |
Using Labels | |
| | |
Chapter 8 | |
| | |
Other Ways to Refer to a Range | |
| | |
The Cells property | |
| | |
The Offset property | |
| | |
Some Useful Range Object Properties | |
| | |
The Text property | |
| | |
The Address property | |
| | |
The Font property | |
| | |
The Formula property | |
| | |
Some Useful Range Object Methods | |
| | |
The Clear method | |
| | |
Chapter 9 | |
| | |
Using Builtin VBA Functions | |
| | |
VBA functions that do more than return a value | |
| | |
Discovering VBA functions | |
| | |
Using Worksheet Functions in VBA | |
| | |
Worksheet function examples | |
| | |
Entering worksheet functions | |
| | |
Using Custom Functions | |
| | |
Chapter 10 | |
| | |
The GoTo Statement | |
| | |
Decisions decisions | |
| | |
The Select Case structure | |
| | |
Knocking Your Code for a Loop | |
| | |
ForNext loops | |
| | |
DoWhile loop | |
| | |
Looping through a Collection | |
| | |
Chapter 11 | |
| | |
Are events useful? | |
| | |
Programming eventhandler procedures | |
| | |
Writing an EventHandler Procedure | |
| | |
Introductory Examples | |
| | |
The BeforeClose event for a workbook | |
| | |
Examples of Activation Events | |
| | |
Activate and deactivate events in a workbook | |
| | |
Workbook activation events | |
| | |
Other WorksheetRelated Events | |
| | |
The Change event | |
| | |
Events Not Associated with Objects | |
| | |
The OnTime event | |
| | |
Keypress events | |
| | |
Chapter 12 | |
| | |
An Erroneous Example | |
| | |
The macros not quite perfect | |
| | |
The macro is still not perfect | |
| | |
Giving up on perfection | |
| | |
Handling Errors Another Way | |
| | |
About the On Error statement | |
| | |
