Get two downloadable books on Excel macros. One teaches you how to write macros. The other provides over 1200 examples and macro solutions.
VISUAL BASIC MACROS MADE EASY is a downloadable book on how to write macros for Microsoft Excel. Written by a user for users. Easily accessible from Excel whenever you need it, the book is full of practical examples that can be copied directly into Excel. Useful for both new and experienced macro writers.
The initial chapters of the book concentrates on teaching you the basics of writing macros. It shows you how to access the Visual Basic editor from within Excel. And, it provides useful customizations to the VB editor that make writing macros easier. There is an entire chapter focused on walking you through the creation of a useful macro, one that will perform any math action you want on a group of cells. The example starts you out with just a few lines of code and then gradually has you add modifications to learn how to write a macro by doing. And, we intentionally have you make mistakes so you experience such events in a planned way.
Subsequent chapters explain how to use variables, link multiple macros together, show you useful techniques on writing macros and go over the many useful features of visual basic.
The VB Made Easy book was written by a user for users. Unlike most books which have two sections in a chapter focused on working with cells and ranges, the VB Made Easy book has two chapters 100% focused on working with cells and ranges. And a full chapter on working with just sheets and a full chapter on working with workbooks. There are also full chapters dedicated to creating toolbars and working with the Excel menus and making changes to them, such as adding a menu item to call your macro.
VISUAL BASIC MACRO EXAMPLES is a downloadable book containing over 1200 examples of Microsoft Excel Visual Basic macros. You can easily search for examples and copy them directly into Excel. All the examples are documented to help you understand them. Easily access directly from Excel.
COMMON FEATURES
The books are actually an enhanced Windows help files. No special software is needed to run. We've enhanced the help file by adding an explorer style navigation window to show the many different categories or chapter titles. And, when you click on a category, it is expanded into its help topics.
The enhanced help file makes searching for a topic quick and easy. Just click on the search button and type in words related to your topic. Those examples containing the search words are displayed in the explorer like window for easy selection.
When you find a topic that has code that will help you, you can highlight the code and copy it. Then go to your macro and paste the code! No retyping at all!
Accessing the help files is easy. You don't have to search through the Windows program listings to find. In Excel you would just select Tools, Macro Systems Add-ins, and select a book to open it. It opens instantly, and can be left open as long as you want. And if there are topics that you want to go to in the future, you can set up bookmarks to the topics inside the enhanced help file!
