Code and further discussion of topics from the book.
Chapter 1 - Why the Macro Recorder Doesn't Work
Chapter 2 - Understanding Visual Basic
Chapter 3 - Referring to Ranges
Chapter 4 - User Defined Functions
New Text for Chapter 5 - If…Then…Else and Select Case
Chapter 5 - Looping
Chapter 6 - Why should I care about R1C1 Formulas?
Chapter 7 - Names
Chapter 8 - Event Programming
Chapter 9 - An Introduction to UserForms
Chapter 10 - Charts
Chapter 11 - Fast Reports with Advanced Filter
Chapter 12 - Pivot Tables
Chapter 13 - 30 Great Macros from the MrExcel Community - Continued
Chapter 13a - Ivan's Track Cell Pointer without Conditional Formatting
Chapter 13b - Tom's Deselect Active Cell Utility
Chapter 13c - 4 Page Setup routines and a timer to track them from Juan Pablo
Chapter 13d - Disable all Cut/Copy/Paste
Chapter 13e - Colo's Hack to capture deletion of a row or column
Chapter 13f - Tom's Utility to hide formula bar when a cell without a lot of text is selected.
Chapter 13g - Nate's Historical Stock Quote Tool
Chapter 14 - Reading from the Web
Chapter 14 - Writing to the Web
Chapter 15 - XML - Only Valid with Excel 2003 or later
Chapter 16 - Automating Word
Chapter 17 - Arrays
Chapter 18 - Text File Processing
Chapter 19 - Enable true multi-user applications with an Access back end
Chapter 20 - Classes, Records, Collections
Chapter 21 - More Userform Techniques
Chapter 22 - Windows API
Chapter 23 - Handling Errors
Chapter 24 - Using Custom Menus
Chapter 25 - Add-Ins and Multi-Workbook Solutions
Chapter 26 - Tushar Mehta's Case Study
Bonus Macros - a Sampler of Hans Herber's
Holy Macro! It's 1,900 Excel VBA Examples
Bonus Macro 1 - Force an Inputbox to accept a numeric entry only
Bonus Macro 2 - Display 3 columns in a combo box
Bonus Macro 3 - Make every option button unselected in a userform
Bonus Macro 4 - Divide a linear array into 4 columns
Bonus Macro 5 - Every number in a range should be entered four times in a new column
Bonus Macro 6 - After entering a value in B1, erase A1 and C1 in 10 seconds
Bonus Macro 7 - Stop Excel from changing URL's to hyperlinks
Bonus Macro 8 - After selecting from a combo box in user form 1, call user form 2 and have the selection appear in the 2nd form.
Bonus Macro 9 - Select a checkbox to hide or show headers/footers
Bonus Macro 10 - Re-order data
Bonus Macro 11 - Replace SKU numbers with names from another sheet
Bonus Macro 12 - Create an array from a filtered recordset
Bonus Macro 13 - Transfer contents of comments to a text file with the data
Bonus Macro 14 - Trick with Option Buttons
Bonus Macro 15 - Extract the year from a text string like "Bill was born in 1965"
Bonus Macro 16 - Populate a combo box every time the sheet is activated
Bonus Macro 17 - Move comments to cells
Bonus Macro 18 - After entering a value in column A, update a formula in B automatically
Bonus Macro 19 - Replace text with abbreviations
Bonus Macro 20 - As the client enters text in column A, it is automatically converted to upper case.
Bonus Macro 21 - Populate a combo box with the names of macros that may be run
Bonus Macro 22 - Create a listbox of items in column A. As the client selects each item, add it to a running shopping list.
Bonus Macro 23 - Sort after every change in Sheet1
Bonus Macro 24 - Scrolling marquee text in a userform
Bonus Macro 25 - Retrieve text from MySQL database on a webserver
Visit MrExcel.com