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
-
相關分類:
Excel、Visual Basic
已絕版
買這商品的人也買了...
-
$2,640$2,508 -
$1,130$1,074 -
$750CCNP 2.0: Routing Exam 640-503 (Hardcover)
-
$399Configuring Cisco AVVID: Architecture for Voice, Video, and Integrated Data
-
$1,130$1,074 -
$625Cisco CCNP Switching Exam Certification Guide
-
$2,030$1,929 -
$240Cisco Networking Academy Program: Engineering Journal and Workbook, Volume II, 2/e (Paperback)
-
$2,540$2,413 -
$345Cisco Networking Academy Program: Engineering Journal and Workbook, Volume I, 2/e (Paperback)
-
$750Flash for the Real World: E-Commerce Case Studies (Paperback)
-
$525Fresh Styles for Web Designers: Eye Candy from the Underground (Paperback)
-
$970Introduction to Algorithms, 2/e
-
$1,330$1,264 -
$700Microsoft Excel 2002 Plain & Simple
-
$1,730$1,644 -
$1,420$1,349 -
$1,274Computer Architecture: A Quantitative Approach, 3/e(精裝本)
-
$1,280$1,216 -
$1,510$1,435 -
$640Building Accessible Websites
-
$750$593 -
$490$323 -
$3,026$2,875 -
$780$663
相關主題
商品描述
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:在工作表上使用對話框控制項
使用貸款計算器
創建一個抗錯誤的貸款計算器
從列表中檢索值