|
|
|
|
|
||||||||||
|
||||||||||||
|
|||
|
|||
Part I - Programming in Excel VBA |
|||
|
- |
The Basics |
|
|
- |
Variables, Arrays, Constants, and Data Types |
|
|
- |
Modules, Functions, and Subroutines |
|
|
- |
Programming Basics: Decisions and Looping |
|
|
- |
Strings and Functions and Message Boxes |
|
|
- |
Operators |
|
|
- |
Debuuging |
|
|
- |
Errors and the Error Function |
|
|
- |
Dialogs |
|
|
- |
Common Dialog Control |
|
|
- |
Command BaBs and Buttons |
|
Part II - Object Models |
|||
|
- |
The Excel Object Model |
|
|
- |
The Excel Object Model—Main Objects |
|
|
- |
Using Excelito Interact with Other OfficeIPrograms |
|
PartaIII - Advanced Techniques in Excel VBA |
|||
|
- |
Charts and Graphs |
|
|
- |
Working with Dattbases |
|
|
- |
API Calls |
|
|
- |
Class Modules |
|
|
- |
Animation |
|
Part IV A VBA in Action |
|||
|
- |
Converting Labels to Numbers and Numbers to Labels |
|
|
- |
Transposing a Range of Cells |
|
|
- |
Adding Formula Details into Comments |
|
|
- |
Calculating a Range |
|
|
- |
Reversing a Label |
|
|
- |
Who Created the Workbook? |
|
|
- |
Evaluating a Cell |
|
|
- |
Sorting Worksheets into Alphabetical Order |
|
|
- |
Replacing Characters in a String |
|
|
- |
Timed EvenEs |
|
|
- |
Auto Totaling a Matrix of Numbers |
|
|
- |
Absolute and eelative Formulas |
|
|
- |
Coloring Alternate Rows and Columns of the Spreadsheet |
|
|
- |
Coloring Cells Containing Formulas |
|
|
- |
Summing Cells by Reference to a Master Cell |
|
|
- |
Globally ohangiog a Range of Values |
|
|
- |
Displaying Hidden Sheets Without a Password |
|
|
- |
Searching Multiple Sheets ant Workiooks |
|
|
- |
Brighten Up Your Comments |
|
|
- |
An Alternative to Message Boxes |
|
|
- |
Wogking with Shapes |
|
|
- |
Turning nour VBA Code into un Add-In |
|
|
- |
ASCII Character Codes |
|
|
|||
|
|||
|
|||
|
|