Microsoft Excel 2002 Visual Basic for Applications Step by Step

Reed Jacobson, Reed Jacobsen

  • 出版商: MicroSoft
  • 出版日期: 2001-10-08
  • 售價: $1,640
  • 貴賓價: 9.5$1,558
  • 語言: 英文
  • 頁數: 336
  • 裝訂: Paperback
  • ISBN: 0735613591
  • ISBN-13: 9780735613591
  • 相關分類: ExcelVisual Basic
  • 已絕版

買這商品的人也買了...

商品描述

Description:

Take creative control of the built-in programming language in Microsoft Excel 2002!

Teach yourself how to use Microsoft® Visual Basic® for Applications (VBA) to take command of Microsoft Excel Version 2002. Choose your own best starting point in this self-paced guide to learn how to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. Easy-to-follow lessons with real-world scenarios and examples show you exactly how to maximize the built-in programming power in Microsoft Excel 2002. Numerous screenshots and a CD full of practice files help you master step-by-step programming procedures. Find out how to create custom solutions with Microsoft Excel and this book—then keep it nearby as an ongoing desktop reference to VBA functions and features. Learn at your own pace how to:

• Use macros to automate simple and complex tasks
• Manipulate workbooks and worksheets
• Explore range objects
• Work with graphical objects
• Build and manipulate PivotTable® objects
• Create loops and conditional statements with Visual Basic
• Use dialog box controls on worksheets
• Create and use custom functions and handle macro errors
• Create custom toolbar buttons, menu commands, command buttons, event handlers, and dialog boxes

 

Table of Contents:

Introduction vii
    Getting Help ix
    Using the Book's CD-ROM xi
    Checking Your Configuration xv
    Conventions and Features xix
PART 1 AUTOMATING EVERYDAY TASKS  
1: Make a Macro Do Simple Tasks 1
    How Visual Basic for Applications Talks to Excel 1
    Creating a Simple Macro 4
    Changing Multiple Properties at Once 9
    Editing a Recorded Macro 13
    Recording Actions in a Macro 15
    Signing Personal Macros 19
2: Make a Macro Do Complex Tasks 24
    Divide and Conquer 26
    Task One: Opening the Report File 27
    Task Two: Filling in Missing Labels 33
    Task Three: Adding a Column of Dates 38
    Task Four: Appending to the Database 40
    Task Five: Deleting the Worksheet 46
    Assembling the Pieces 47
PART 2 EXPLORING OBJECTS  
3: Explore Workbooks and Worksheets 50
    Understanding Workbooks 55
    Understanding Worksheets 62
4: Explore Graphical Objects 68
    Exploring Graphical Objects 69
    Exploring Chart Objects 78
5: Explore Range Objects 88
    Referring to a Range 90
    Formatting a Range 102
    Entering Values and Formulas into a Range 108
    Enhancing Recorded Selections 116
6: Explore PivotTable Objects 120
    Building PivotTables 121
    Refining PivotTables 131
PART 3 EXPLORING VISUAL BASIC  
7: Control Visual Basic 140
    Using Conditionals 141
    Creating Loops 148
    Managing Large Loops 155
8: Extend Excel and Visual Basic 162
    Creating Custom Functions 164
    Handling Errors 170
PART 4 MAKING MACROS EASY TO USE  
9: Launch Macros with Events 182
    Creating Custom Toolbars and Menus 184
    Creating Custom Command Buttons 192
    Handling Worksheet and Workbook Events 202
10: Use Dialog Box Controls on a Worksheet 208
    Using a Loan Payment Calculator 209
    Creating an Error-Resistant Loan Payment Calculator 212
    Retrieving a Value from a List 216
    Protecting the Worksheet 221
11: Create a Custom Form 224
    Creating a Form's User Interface 225
    Preparing a Form's Functionality 240
    Implementing a Form 246
12: Create an Enterprise Information System 254
    Examining an Existing Enterprise Information System 256
    Charting Data from a Database 259
    Controlling the Report with Macros 272
    Creating a Graphical Interface 274
    Packaging the Application 284
INDEX 295