Excel VBA Macro Programming

Contents            

Part I: Programming in Excel VBA

1: The Basics

2: Variables, Arrays, Constants, and Data Types

3: Modules, Functions, and Subroutines

4: Programming Basics: Decisions and Looping

5: Strings and Functions and Message Boxes

6: Operators

7: Debugging

8: Errors and the Error Function

9: Dialogs

10: Common Dialog Control

11: Command Bars and Buttons

Part II: Object Models

12: The Excel Object Model

13: The Excel Object Model-Main Objects

14: Using Excel to Interact with Other Office Programs

Part III: Advanced Techniques in Excel VBA

15: Charts and Graphs

16: Working with Databases

17: API Calls

18: Class Modules

19: Animation

Part IV: VBA in Action

20: Converting Labels to Numbers and Numbers to Labels

21: Transposing a Range of Cells

22: Adding Formula Details into Comments

23: Calculating a Range

24: Reversing a Label

25: Who Created the Workbook?

26: Evaluating a Cell

27: Sorting Worksheets into Alphabetical Order

28: Replacing Characters in a String

29: Timed Events

30: Auto Totaling a Matrix of Numbers

31: Absolute and Relative Formulas

32: Coloring Alternate Rows and Columns of the Spreadsheet

33: Coloring Cells Containing Formulas

34: Summing Cells by Reference to a Master Cell

35: Globally Changing a Range of Values

36: Displaying Hidden Sheets Without a Password

37: Searching Multiple Sheets and Workbooks

38: Brighten Up Your Comments

39: An Alternative to Message Boxes

40: Working with Shapes

41: Turning Your VBA Code into an Add-In

A: ASCII Character Codes