Excel VBA Macro Programming

Richard Shepherd

  • 出版商: McGraw-Hill Education
  • 出版日期: 2004-02-04
  • 售價: $1,150
  • 貴賓價: 9.5$1,093
  • 語言: 英文
  • 頁數: 320
  • 裝訂: Paperback
  • ISBN: 0072231440
  • ISBN-13: 9780072231441
  • 相關分類: Excel

已絕版

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

相關主題

商品描述

            

Part I: Programming in Excel VBA
1: The Basics
2: Variables, Arrays, Constants, and Data Types
3: Modules, Functions, and Subroutines
4: Programming Basics: Decisions and Looping
5: Strings and Functions and Message Boxes
6: Operators
7: Debugging
8: Errors and the Error Function
9: Dialogs
10: Common Dialog Control
11: Command Bars and Buttons
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes