Get beyond the basics with Excel 2007 macros Here is the perfect solution for the spreadsheet user who wants to learn powerful shortcuts and time-saving methods for expediting and remembering tasks. This inexpensive guide explains how to use Excel macros to simplify repetitive tasks, store the instructions for complicated tasks, and make standard commands available to other users. You will create your first macro in just one minute and learn to produce interactive macros that ask the user for input and add macros to the Excel toolbar.
Get beyond the basics with Excel 2007 macros Here is the perfect solution for the spreadsheet user who wants to learn powerful shortcuts and time-saving methods for expediting and remembering tasks. This inexpensive guide explains how to use Excel macros to simplify repetitive tasks, store the instructions for complicated tasks, and make standard commands available to other users. You will create your first macro in just one minute and learn to produce interactive macros that ask the user for input and add macros to the Excel toolbar.
Gail Perry (Indianapolis, IN) is a CPA, author and software trainer from Indianapolis, IN. She has been editing the TurboTax product documentation for Intuit for the past several years. In addition, she's written several books on Excel, including Excel Answers 2000! for Osborne.
Inhaltsangabe
Introduction Chapter 1. Recording Macros Chapter 2. Editing Macros Chapter 3. Creating Macros in Visual Basic Chapter 4. Storing Macros Chapter 5. Understanding Macro Commands Chapter 6. Using Visual Basic Subroutines and Creating Functions Chapter 7. Creating Interactive Macros Chapter 8. Using Macros to Format Cells Chapter 9. Using Variables in Macros Chapter 10. Creating If/Then/Else Routines Chapter 11. Exploring Loops Chapter 12. Adding Controls to Your Worksheets Index