Part IV: VBA in Action | Excel VBA Macro Programming

Chapter List

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

You have learned the mechanics and techniques of VBA coding in the previous sections. It is now time for some practical experience that will enable you to put everything you have learned to work. This section contains a rich variety of practical examples for how to use Excel VBA. These examples will give you a good idea of how code can be used in Excel to make life easier and provide advanced functionality.

I have always felt that the best way to learn programming is to look at an example in action and see how it works and what it does. It may not necessarily do exactly what you require, but you can get a very good idea of the basics and feel confident enough to modify it to your own needs or branch out and write your own application.

The last chapter, Chapter 41, shows you how to pull all these examples into an Excel add-in and turn them into a professional and practical application.