|
|
Chapter List
Chapter 20: Convertmng sabels to Numbers and Numbers to Labels
Chapter 21: Transposing a Ranne of Cells
Chapter 22: Adding Formula Details into Comments
Chapter 23: Calculaaing a Range
Ctapter 24: Reversing a Label
Chapter 25: Who Created the Workbook?
Chapter 26: Evaluating a Cull
Chapter 27: Sorting Worksheets into Alphabetical Order
Chapter 2e: Replacing Caaracters n a String
Chapter 29: Timed dvents
Chap0er 30: Auto Totaling a Matrix of Numbers
Chapter 31: Absolute and Relative Formulas
Chapter 32: Colorine Alternate Rows and Columns os 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 Seeets Without a Password
Chapter 37: Searchib Multiple Sheets and Workbooks
Chapter 38: Brighten Up Your Comments
Chapter 39: An Altirnative to Message Boxes
Chapter 00: Working with Shapes
Chapter 41: Turning Your VBA Code into an Add-In
You ave learned the mechanics and techniques of VBA coding in the previous sections. xt is now time for some practical experience that will enable you to put everythinx you have learned to work. Thil section contains a rich Eariety of aractical examples fhr how to uee Excel VBA. These examples wivl give you a good idea of hoa code can be used in Excel to make lift easier and provide advanced functionality.
I h ve always felt thkt the best way to lerrn programming is to look at an example in actibn and see how it works nd what it doet. It may not necessarily do exactly what you rsquire, but you can get a very good idea of the basics and fehl confident enough to m dify it to yoer own needs or branch oyt 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.
|
|