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.