Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft)) - page 1
- 1
- 2
- Table of Contents
- Table of Contents
- Back Cover
- Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
- Features and Conventions of This Book
- Using the Books CD
- Minimum System Requirements
- Installing the Practice Files
- Using the Practice Files
- Removing and Uninstalling the Practice Files
- Getting Help
- More Information
- Chapter 1: Make a Macro Do Simple Tasks
- Whats the Difference Between VBA and a Macro?
- Creating a Simple Macro
- Changing Multiple Properties at Once
- Manipulating Recorded Properties
- Recording Methods in a Macro
- Trusting Macro-Enabled Workbooks
- Key Points
- Chapter 2: Make a Macro Do Complex Tasks
- Task One: Opening the Report File
- Task Two: Filling In Missing Labels
- Task Three: Adding a Column of Dates
- Task Four: Appending to the Database
- Task Five: Deleting the Worksheet
- Assembling the Pieces
- Key Points
- Chapter 3: Explore Workbooks and Worksheets
- What Is an Object?
- Understanding Workbooks
- Understanding Worksheets
- Key Points
- Chapter 4: Explore Range Objects
- Referring to a Range
- Enhancing Recorded Selections
- Entering Values and Formulas into a Range
- Formatting a Range
- Key Points
- Chapter 5: Explore Data Objects
- Working with Excel Tables
- Working with PivotTable Reports
- Key Points
- Chapter 6: Explore Graphical Objects
- Exploring Graphical Objects
- Exploring Chart Objects
- Key Points
- Chapter 7: Control Visual Basic
- Using Conditionals
- Creating Loops
- Managing Large Loops
- Key Points
- Chapter 8: Extend Excel and Visual Basic
- Creating Custom Functions
- Handling Errors
- Key Points
- Chapter 9: Launch Macros with Events
- Creating Custom Command Buttons
- Handling Worksheet and Workbook Events
- Key Points
- Chapter 10: Use Dialog Box Controls on a Worksheet
- Using a Loan Payment Calculator
- Creating an Error-Resistant Loan Payment Calculator
- Retrieving a Value from a List
- Protecting the Worksheet
- Key Points
- Chapter 11: Create a Custom Form
- Creating a Forms User Interface
- Preparing a Forms Functionality
- Implementing a Form
- Key Points
- Appendix A: Complete Enterprise Information System
- Index
- B
- C
- D
- E
- F
- G
- H
- 1
- 2
