Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
---|---|---|---|---|---|
Searching... | 30000010254126 | HF5548.4.M523 P474 2009 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Get beyond the basics with Excel 2007 macros
Now you can take your Excel skills to the next level with help from this hands-on guide. Excel 2007 Macros Made Easy shows you how to create, run, and revise macros to simplify repetitive tasks and store the instructions for complicated ones. You'll learn to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share your macros with other users. Discover how easy it is to develop custom macros, save time, and boost productivity.
Record and edit macrosCreate and debug macros in VBA
Save macros to the Personal Macro Workbook or other workbooks
Create VBA subroutines and functions
Develop interactive macros
Format cells using macros
Create variables and arrays
Apply logic to macros with If/Then/Else routines
Use loops to process data
Add controls to your worksheets
Author Notes
Gail Perry is a CPA, financial journalist, the author more than 20 books on financial software, taxes, and personal finance. She is the managing editor for AccountingWEB, a contributing editor for SMBFinance magazine, and an instructor.
Table of Contents
Chapter 1 Recording Macros | p. 1 |
Chapter 2 Editing Macros | p. 19 |
Chapter 3 Creating Macros in Visual Basic | p. 35 |
Chapter 4 Storing Macros | p. 53 |
Chapter 5 Understanding Macro Commands | p. 73 |
Chapter 6 Using Visual Basic Subroutines and Creating Functions | p. 91 |
Chapter 7 Creating Interactive Macros | p. 103 |
Chapter 8 Using Macros to Format Cells | p. 119 |
Chapter 9 Using Variables in Macros | p. 133 |
Chapter 10 Creating If/Then/Else Routines | p. 147 |
Chapter 11 Exploring Loops | p. 157 |
Chapter 12 Adding Controls to Your Worksheets | p. 171 |
Index | p. 183 |