Microsoft Excel 2002 Visual Basic for Applications Step by Step
暫譯: Microsoft Excel 2002 VBA 實用指南

Reed Jacobson, Reed Jacobsen

  • 出版商: MicroSoft
  • 出版日期: 2001-10-08
  • 售價: $1,690
  • 貴賓價: 9.5$1,606
  • 語言: 英文
  • 頁數: 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

商品描述(中文翻譯)

描述:
掌握 Microsoft Excel 2002 內建的程式語言,發揮創意控制力!自學如何使用 Microsoft® Visual Basic® for Applications (VBA) 來掌控 Microsoft Excel 2002 版本。在這本自學指南中選擇最適合自己的起點,學習如何自動化電子表格、撰寫自己的函數和程序、自訂選單和工具列等。易於跟隨的課程搭配真實世界的情境和範例,讓你確切了解如何最大化 Microsoft Excel 2002 的內建程式設計能力。大量的螢幕截圖和一張滿載練習檔案的 CD 幫助你逐步掌握程式設計程序。了解如何使用 Microsoft Excel 創建自訂解決方案,並將這本書作為 VBA 函數和功能的持續桌面參考。按照自己的步調學習如何:
• 使用巨集自動化簡單和複雜的任務
• 操作工作簿和工作表
• 探索範圍物件
• 使用圖形物件
• 建立和操作 PivotTable® 物件
• 使用 Visual Basic 創建迴圈和條件語句
• 在工作表上使用對話框控制項
• 創建和使用自訂函數並處理巨集錯誤
• 創建自訂工具列按鈕、選單命令、命令按鈕、事件處理程序和對話框

目錄:
引言
獲取幫助
使用本書的 CD-ROM
檢查您的配置
慣例和特徵
第一部分 自動化日常任務
1:讓巨集執行簡單任務
如何 Visual Basic for Applications 與 Excel 互動
創建簡單的巨集
一次更改多個屬性
編輯錄製的巨集
在巨集中錄製操作
簽署個人巨集
2:讓巨集執行複雜任務
分而治之
任務一:打開報告檔案
任務二:填寫缺失的標籤
任務三:添加日期列
任務四:附加到資料庫
任務五:刪除工作表
組裝各部分
第二部分 探索物件
3:探索工作簿和工作表
理解工作簿
理解工作表
4:探索圖形物件
探索圖形物件
探索圖表物件
5:探索範圍物件
引用範圍
格式化範圍
在範圍中輸入值和公式
增強錄製的選擇
6:探索 PivotTable 物件
建立 PivotTable
精煉 PivotTable
第三部分 探索 Visual Basic
7:控制 Visual Basic
使用條件語句
創建迴圈
管理大型迴圈
8:擴展 Excel 和 Visual Basic
創建自訂函數
處理錯誤
第四部分 使巨集易於使用
9:使用事件啟動巨集
創建自訂工具列和選單
創建自訂命令按鈕
處理工作表和工作簿事件
10:在工作表上使用對話框控制項
使用貸款計算器
創建一個抗錯誤的貸款計算器
從列表中檢索值