---

Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))

ISBN: 0735613591
EAN: 2147483647

Year: 2004
Pages: 99

Authors: Reed Jacobsen

BUY ON AMAZON

• 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
• I
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Z
• List of Figures
• List of Sidebars
• CD Content