reklama - zainteresowany?

Writing Excel Macros with VBA. 2nd Edition - Helion

Writing Excel Macros with VBA. 2nd Edition
ebook
Autor: PhD Steven Roman
ISBN: 978-05-965-5523-8
stron: 574, Format: ebook
Data wydania: 2002-06-25
Księgarnia: Helion

Cena książki: 118,15 zł (poprzednio: 137,38 zł)
Oszczędzasz: 14% (-19,23 zł)

Dodaj do koszyka Writing Excel Macros with VBA. 2nd Edition

Tagi: Excel | VBA - Programowanie

Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:

  • The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros.
The VBA programming language, the same programming language used by the other applications in Microsoft Office XP and 2000, as well as by the retail editions of Visual Basic 6.0. The Excel object model, including new objects and new members of existing objects in Excel 2002. Excel exposes nearly all of its functionality through its object model, which is the means by which Excel can be controlled programmatically using VBA. While the Excel object model, with 192 objects, is the second largest among the Office applications, you need to be familiar with only a handful of objects to write effective macros. Writing Excel Macros focuses on these essential objects, but includes a discussion of many more objects as well.Writing Excel Macros with VBA, 2nd Edition is written in a terse, no-nonsense manner that is characteristic of Steven Roman's straightforward, practical approach. Instead of a slow-paced tutorial with a lot of handholding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This tutorial is reinforced by interesting and useful examples that solve common problems you're sure to have encountered.Writing Excel Macros with VBA, 2nd Edition is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity.

Dodaj do koszyka Writing Excel Macros with VBA. 2nd Edition

 

Osoby które kupowały "Writing Excel Macros with VBA. 2nd Edition", wybierały także:

  • Excel 2019. Kurs video. Postaw pierwsze kroki!
  • Przetwarzanie danych w Excelu. Kurs video. Laboratorium Power Query
  • Excel VBA. Kurs video. Budowanie procesu automatycznego raportowania
  • Power Query i Power Pivot. Kurs video. Poznaj narzÄ™dzia Excel BI
  • Microsoft Excel 2013 Budowanie modeli danych przy użyciu PowerPivot

Dodaj do koszyka Writing Excel Macros with VBA. 2nd Edition

Spis treści

Writing Excel Macros with VBA. 2nd Edition eBook -- spis treści

  • Writing Excel Macros with VBA, 2nd Edition
    • SPECIAL OFFER: Upgrade this ebook with OReilly
    • A Note Regarding Supplemental Files
    • Preface
      • Preface to the Second Edition
      • The Books Audience
      • Organization of This Book
      • The Book's Text and Sample Code
      • About the Code
      • Conventions in this Book
      • Obtaining the Sample Programs
      • How to Contact Us
      • Acknowledgments
    • 1. Introduction
      • 1.1. Selecting Special Cells
      • 1.2. Setting a Chart's Data Point Labels
      • 1.3. Topics in Learning Excel Programming
    • I. The VBA Environment
      • 2. Preliminaries
        • 2.1. What Is a Programming Language?
        • 2.2. Programming Style
          • 2.2.1. Comments
          • 2.2.2. Readability
          • 2.2.3. Modularity
      • 3. The Visual Basic Editor, Part I
        • 3.1. The Project Window
          • 3.1.1. Project Names
          • 3.1.2. Project Contents
            • 3.1.2.1. The ThisWorkbook object
            • 3.1.2.2. Sheet objects
            • 3.1.2.3. Standard modules
            • 3.1.2.4. Class modules
            • 3.1.2.5. UserForm objects
        • 3.2. The Properties Window
        • 3.3. The Code Window
          • 3.3.1. Procedure and Full-Module Views
          • 3.3.2. The Object and Procedure List Boxes
            • 3.3.2.1. A workbook or sheet object
            • 3.3.2.2. A standard module
            • 3.3.2.3. A UserForm object
        • 3.4. The Immediate Window
        • 3.5. Arranging Windows
          • 3.5.1. Docking
      • 4. The Visual Basic Editor, Part II
        • 4.1. Navigating the IDE
          • 4.1.1. General Navigation
            • 4.1.1.1. Navigating the code window at design time
            • 4.1.1.2. Tracing code
            • 4.1.1.3. Bookmarks
        • 4.2. Getting Help
        • 4.3. Creating a Procedure
        • 4.4. Run Time, Design Time, and Break Mode
        • 4.5. Errors
          • 4.5.1. Design-Time Errors
          • 4.5.2. Compile-Time Errors
          • 4.5.3. Run-Time Errors
          • 4.5.4. Logical Errors
        • 4.6. Debugging
          • 4.6.1. Tracing
            • 4.6.1.1. Stepping into
            • 4.6.1.2. Step Over (Shift-F8 or choose Step Over from the Debug menu)
            • 4.6.1.3. Step Out (Ctrl-Shift-F8 or choose Step Out from the Debug menu)
            • 4.6.1.4. Run To Cursor (Ctrl-F8 or choose Run To Cursor from the Debug menu)
            • 4.6.1.5. Set Next Statement (Ctrl-F9 or choose Set Next Statement from the Debug menu)
            • 4.6.1.6. Breaking out of Debug mode
          • 4.6.2. Watching Expressions
            • 4.6.2.1. Quick Watch (Shift-F9)
            • 4.6.2.2. The Locals and Watches windows
        • 4.7. Macros
          • 4.7.1. Recording Macros
          • 4.7.2. Running Macros
    • II. The VBA Programming Language
      • 5. Variables, Data Types, and Constants
        • 5.1. Comments
        • 5.2. Line Continuation
        • 5.3. Constants
          • 5.3.1. Enums
        • 5.4. Variables and Data Types
          • 5.4.1. Variable Declaration
          • 5.4.2. The Importance of Explicit Variable Declaration
            • 5.4.2.1. Option Explicit
          • 5.4.3. Numeric Data Types
          • 5.4.4. Boolean Data Type
          • 5.4.5. String Data Type
          • 5.4.6. Date Data Type
          • 5.4.7. Variant Data Type
          • 5.4.8. Excel Object Data Types
            • 5.4.8.1. The generic As Object declaration
            • 5.4.8.2. The Set statement
          • 5.4.9. Arrays
            • 5.4.9.1. The dimension of an array
            • 5.4.9.2. Dynamic arrays
            • 5.4.9.3. The UBound function
          • 5.4.10. Variable Naming Conventions
          • 5.4.11. Variable Scope
            • 5.4.11.1. Procedure-level (local) variables
            • 5.4.11.2. Module-level variables
          • 5.4.12. Variable Lifetime
            • 5.4.12.1. Static variables
          • 5.4.13. Variable Initialization
        • 5.5. VBA Operators
      • 6. Functions and Subroutines
        • 6.1. Calling Functions
        • 6.2. Calling Subroutines
        • 6.3. Parameters and Arguments
          • 6.3.1. Optional Arguments
          • 6.3.2. Named Arguments
          • 6.3.3. ByRef Versus ByVal Parameters
        • 6.4. Exiting a Procedure
        • 6.5. Public and Private Procedures
        • 6.6. Project References
          • 6.6.1. Fully Qualified Procedure Names
      • 7. Built-in Functions and Statements
        • 7.1. The MsgBox Function
        • 7.2. The InputBox Function
        • 7.3. VBA String Functions
        • 7.4. Miscellaneous Functions and Statements
          • 7.4.1. The Is Functions
            • 7.4.1.1. The IsDate function
            • 7.4.1.2. The IsEmpty function
            • 7.4.1.3. The IsNull function
            • 7.4.1.4. The IsNumeric function
          • 7.4.2. The Immediate If Function
          • 7.4.3. The Switch Function
          • 7.4.4. Units Conversions
          • 7.4.5. The Beep Statement
        • 7.5. Handling Errors in Code
          • 7.5.1. The On Error Goto Label Statement
          • 7.5.2. The Error Object
          • 7.5.3. The On Error GoTo 0 Statement
          • 7.5.4. The On Error Resume Next Statement
          • 7.5.5. The Resume Statement
      • 8. Control Statements
        • 8.1. The If...Then Statement
        • 8.2. The For Loop
          • 8.2.1. Exit For
        • 8.3. The For Each Loop
        • 8.4. The Do Loop
        • 8.5. The Select Case Statement
        • 8.6. A Final Note on VBA
          • 8.6.1. File-Related Functions
          • 8.6.2. Date- and Time-Related Functions
          • 8.6.3. The Format Function
    • III. Excel Applications and the Excel Object Model
      • 9. Object Models
        • 9.1. Objects, Properties, and Methods
          • 9.1.1. Properties
          • 9.1.2. Methods
        • 9.2. Collection Objects
          • 9.2.1. The Base of a Collection
        • 9.3. Object Model Hierarchies
        • 9.4. Object Model Syntax
        • 9.5. Object Variables
          • 9.5.1. The With Statement
          • 9.5.2. Object Variables Save Execution Time
          • 9.5.3. An Object Variable Is a Pointer
          • 9.5.4. Freeing an Object Variable: the Nothing Keyword
          • 9.5.5. The Is Operator
          • 9.5.6. Default Members
          • 9.5.7. Global Members
      • 10. Excel Applications
        • 10.1. Providing Access to an Application's Features
          • 10.1.1. Working with Toolbars and Menus Interactively
          • 10.1.2. Assigning Macros to Menus and Toolbars
        • 10.2. Where to Store an Application
          • 10.2.1. The Excel Startup Folder
          • 10.2.2. Excel Templates
          • 10.2.3. Excel Add-Ins
            • 10.2.3.1. Creating an add-in
            • 10.2.3.2. Characteristics of an add-in
            • 10.2.3.3. Debugging add-ins
            • 10.2.3.4. Deleting an add-in
        • 10.3. An Example Add-In
          • 10.3.1. Creating the Source Workbook
          • 10.3.2. Setting Up the Custom Menus
          • 10.3.3. Implementing the Features of the Add-In
          • 10.3.4. Final Steps
      • 11. Excel Events
        • 11.1. The EnableEvents Property
        • 11.2. Events and the Excel Object Model
        • 11.3. Accessing an Event Procedure
        • 11.4. Worksheet Events
        • 11.5. WorkBook Events
        • 11.6. Chart Events
        • 11.7. Application Events
        • 11.8. QueryTable Refresh Events
      • 12. Custom Menus and Toolbars
        • 12.1. Menus and Toolbars: An Overview
          • 12.1.1. Menu Terminology
          • 12.1.2. The CommandBar Object
          • 12.1.3. Command-Bar Controls
            • 12.1.3.1. Popup controls
            • 12.1.3.2. Button controls
          • 12.1.4. Adding a Menu Item
        • 12.2. The CommandBars Collection
        • 12.3. Creating a New Menu Bar or Toolbar
        • 12.4. Command-Bar Controls
          • 12.4.1. Creating a New Command-Bar Control
        • 12.5. Built-in Command-Bar-Control IDs
        • 12.6. Example: Creating a Menu
        • 12.7. Example: Creating a Toolbar
        • 12.8. Example: Adding an Item to an Existing Menu
        • 12.9. Augmenting the SRXUtils Application
          • 12.9.1. Creating the Data Worksheet
          • 12.9.2. Setting Up the Custom Menus
          • 12.9.3. Implementing the Features of the Add-in
          • 12.9.4. Closing Any Open Add-Ins
      • 13. Built-In Dialog Boxes
        • 13.1. The Show Method
      • 14. Custom Dialog Boxes
        • 14.1. What Is a UserForm Object?
        • 14.2. Creating a UserForm Object
        • 14.3. ActiveX Controls
        • 14.4. Adding UserForm Code
        • 14.5. Excel's Standard Controls
        • 14.6. Example: The ActivateSheet Utility
          • 14.6.1. Back to SRXUtils
          • 14.6.2. Create the UserForm
            • 14.6.2.1. List box
            • 14.6.2.2. Activate button
            • 14.6.2.3. Cancel button
          • 14.6.3. Create the Code Behind the UserForm
            • 14.6.3.1. Cancel button code
            • 14.6.3.2. ActivateSelectedSheet procedure
            • 14.6.3.3. Activate button code
            • 14.6.3.4. Double-click lstSheets code
            • 14.6.3.5. Enter key event
            • 14.6.3.6. Fill the lstSheets list box
          • 14.6.4. Trying the Activate Utility
        • 14.7. ActiveX Controls on Worksheets
          • 14.7.1. Referring to a Control on a Worksheet
          • 14.7.2. Adding a Control to a Worksheet Programmatically
      • 15. The Excel Object Model
        • 15.1. A Perspective on the Excel Object Model
        • 15.2. Excel Enums
        • 15.3. The VBA Object Browser
      • 16. The Application Object
        • 16.1. Properties and Methods of the Application Object
          • 16.1.1. Members that Return Children
          • 16.1.2. Members that Affect the Display
          • 16.1.3. Members that Enable Excel Features
          • 16.1.4. Event-Related Members
            • 16.1.4.1. OnKey method
            • 16.1.4.2. OnTime method
          • 16.1.5. Calculation-Related Members
            • 16.1.5.1. Calculate method
            • 16.1.5.2. CalculateFullRebuild method
            • 16.1.5.3. Calculation property (R/W Long)
            • 16.1.5.4. CalculateBeforeSave property (R/W Boolean)
            • 16.1.5.5. CheckAbort method
          • 16.1.6. File-Related Members
            • 16.1.6.1. DefaultFilePath property (R/W String)
            • 16.1.6.2. DefaultSaveFormat property (R/W Long)
            • 16.1.6.3. FileDialog property
            • 16.1.6.4. FindFile method
            • 16.1.6.5. GetOpenFilename method
            • 16.1.6.6. GetSaveAsFilename method
            • 16.1.6.7. RecentFiles property (Read-Only)
            • 16.1.6.8. SaveWorkspace method
          • 16.1.7. Members that Affect the Current State of Excel
          • 16.1.8. Members that Produce Actions
            • 16.1.8.1. ConvertFormula method
            • 16.1.8.2. Evaluate method
            • 16.1.8.3. Goto method
            • 16.1.8.4. Quit method
          • 16.1.9. Miscellaneous Members
            • 16.1.9.1. CellFormat, FindFormat and ReplaceFormat object
            • 16.1.9.2. InputBox method
            • 16.1.9.3. Selection property
            • 16.1.9.4. StatusBar property (R/W String)
            • 16.1.9.5. Intersect method
            • 16.1.9.6. Union method
        • 16.2. Children of the Application Object
          • 16.2.1. Name Objects and the Names Collections
          • 16.2.2. The Windows Collection and Window Objects
          • 16.2.3. The WorksheetFunction Object
      • 17. The Workbook Object
        • 17.1. The Workbooks Collection
          • 17.1.1. Add Method
          • 17.1.2. Close Method
          • 17.1.3. Count Property
          • 17.1.4. Item Property
          • 17.1.5. Open Method
          • 17.1.6. OpenText Method
        • 17.2. The Workbook Object
          • 17.2.1. Activate Method
          • 17.2.2. Close Method
          • 17.2.3. DisplayDrawingObjects Property
          • 17.2.4. FileFormat Property (Read-Only Long )
          • 17.2.5. Name, FullName, and Path Properties
          • 17.2.6. HasPassword Property (Read-Only Boolean)
          • 17.2.7. PrecisionAsDisplayed Property (R/W Boolean)
          • 17.2.8. PrintOut Method
          • 17.2.9. PrintPreview Method
          • 17.2.10. Protect Method
          • 17.2.11. ReadOnly Property (Read-Only Boolean)
          • 17.2.12. RefreshAll Method
          • 17.2.13. Save Method
          • 17.2.14. SaveAs Method
          • 17.2.15. SaveCopyAs Method
          • 17.2.16. Saved Property (R/W Boolean)
        • 17.3. Children of the Workbook Object
          • 17.3.1. The CustomView Object
          • 17.3.2. The Names Collection
          • 17.3.3. The Sheets Collection
          • 17.3.4. The Styles Collection and the Style Object
        • 17.4. Example: Sorting Sheets in a Workbook
      • 18. The Worksheet Object
        • 18.1. Properties and Methods of the Worksheet Object
        • 18.2. Children of the Worksheet Object
        • 18.3. Protection in Excel XP
          • 18.3.1. The Protection Object
          • 18.3.2. The AllowEditRange Object
          • 18.3.3. The UserAccess Objects
        • 18.4. Example: Printing Sheets
          • 18.4.1. Create the UserForm
            • 18.4.1.1. List box
            • 18.4.1.2. Print button
            • 18.4.1.3. Cancel button
          • 18.4.2. Create the Code Behind the UserForm
            • 18.4.2.1. The Declarations section
            • 18.4.2.2. Cancel button code
            • 18.4.2.3. Print button code
            • 18.4.2.4. The Form's Initialize event
            • 18.4.2.5. The PrintSheets procedure
      • 19. The Range Object
        • 19.1. The Range Object as a Collection
        • 19.2. Defining a Range Object
          • 19.2.1. Range Property
          • 19.2.2. Cells Property
          • 19.2.3. Column, Columns, Row, and Rows Properties
          • 19.2.4. Offset Property
        • 19.3. Additional Members of the Range Object
          • 19.3.1. Activate Method
          • 19.3.2. AddComment Method
          • 19.3.3. Address Property (Read-Only String)
          • 19.3.4. AutoFill Method
          • 19.3.5. AutoFilter Method
          • 19.3.6. AutoFit Method
          • 19.3.7. AutoFormat Method
          • 19.3.8. BorderAround Method
          • 19.3.9. Calculate Method
          • 19.3.10. Clear Methods
          • 19.3.11. ColumnDifferences and RowDifferences Methods
          • 19.3.12. ColumnWidth and RowHeight Properties
          • 19.3.13. Width, Height, Top, and Left Properties
          • 19.3.14. Consolidate Method
          • 19.3.15. Copy and Cut Methods
          • 19.3.16. CopyFromRecordset Method
          • 19.3.17. CreateNames Method
          • 19.3.18. CurrentRegion Property
          • 19.3.19. Delete Method
          • 19.3.20. Dependents and DirectDependents Properties
          • 19.3.21. Precedents and DirectPrecedents Properties
          • 19.3.22. End Property
          • 19.3.23. EntireColumn and EntireRow Properties
          • 19.3.24. Fill Methods
          • 19.3.25. Find Method
          • 19.3.26. FindNext and FindPrevious Methods
          • 19.3.27. Formula and FormulaR1C1 Properties
          • 19.3.28. FormulaArray Property
          • 19.3.29. FormulaHidden Property (R/W Boolean)
          • 19.3.30. HasFormula Property (Read-Only)
          • 19.3.31. HorizontalAlignment Property
          • 19.3.32. IndentLevel Property and InsertIndent Method
          • 19.3.33. Insert Method
          • 19.3.34. Locked Property
          • 19.3.35. Merge-Related Methods and Properties
          • 19.3.36. Next and Previous Properties
          • 19.3.37. NumberFormat Property
          • 19.3.38. Parse Method
          • 19.3.39. PasteSpecial Method
          • 19.3.40. PrintOut Method
          • 19.3.41. PrintPreview Method
          • 19.3.42. Replace Method
          • 19.3.43. Select Method
          • 19.3.44. ShrinkToFit Property
          • 19.3.45. Sort Method
          • 19.3.46. SpecialCells Method
          • 19.3.47. TextToColumns Method
          • 19.3.48. Value Property
          • 19.3.49. WrapText Property
        • 19.4. Children of the Range Object
          • 19.4.1. The Areas Collection
          • 19.4.2. The Borders Collection
          • 19.4.3. The Border Object
            • 19.4.3.1. Color property
            • 19.4.3.2. ColorIndex property
            • 19.4.3.3. LineStyle property
            • 19.4.3.4. Weight property
          • 19.4.4. The Characters Object
          • 19.4.5. The Comment Object
          • 19.4.6. The Font Object
          • 19.4.7. The FormatConditions Collection
          • 19.4.8. The Interior Object
            • 19.4.8.1. Color and ColorIndex properties
            • 19.4.8.2. Pattern property
            • 19.4.8.3. PatternColor and PatternColorIndex properties
          • 19.4.9. The PivotField, PivotItem, and PivotTable Objects
          • 19.4.10. The QueryTable Object
          • 19.4.11. The Validation Object
        • 19.5. Example: Getting the Used Range
        • 19.6. Example: Selecting Special Cells
          • 19.6.1. Designing the Utility
          • 19.6.2. Designing the Dialog
            • 19.6.2.1. The Frame control
            • 19.6.2.2. Control names
            • 19.6.2.3. Tab Order
            • 19.6.2.4. Some final tips
          • 19.6.3. Writing the Code
      • 20. Pivot Tables
        • 20.1. Pivot Tables
        • 20.2. The PivotTable Wizard
        • 20.3. The PivotTableWizard Method
        • 20.4. The PivotTable Object
          • 20.4.1. Naming Data Fields
          • 20.4.2. The Complete Code
        • 20.5. Properties and Methods of the PivotTable Object
          • 20.5.1. Returning a Fields Collection
            • 20.5.1.1. ColumnFields property
            • 20.5.1.2. DataFields property
            • 20.5.1.3. HiddenFields property
            • 20.5.1.4. PageFields property
            • 20.5.1.5. PivotFields property
            • 20.5.1.6. RowFields property
            • 20.5.1.7. VisibleFields property
          • 20.5.2. Totals-Related Members
          • 20.5.3. Returning a Portion of a PivotTable
            • 20.5.3.1. ColumnRange property
            • 20.5.3.2. DataBodyRange property
            • 20.5.3.3. DataLabelRange property
            • 20.5.3.4. PageRange and PageRangeCells properties
            • 20.5.3.5. RowRange property
            • 20.5.3.6. TableRange1 property
            • 20.5.3.7. TableRange2 property
          • 20.5.4. PivotSelect and PivotSelection
          • 20.5.5. Additional Members of the PivotTable Object
            • 20.5.5.1. AddFields method
            • 20.5.5.2. CalculatedFields method
            • 20.5.5.3. Errors-related properties
            • 20.5.5.4. Null-related properties
            • 20.5.5.5. EnableDrillDown property
            • 20.5.5.6. Formatting properties and methods
            • 20.5.5.7. Refreshing a pivot table
            • 20.5.5.8. PageField-related properties
            • 20.5.5.9. Name property
            • 20.5.5.10. SaveData property (R/W Boolean)
            • 20.5.5.11. ShowPages method
            • 20.5.5.12. SourceData property
        • 20.6. Children of the PivotTable Object
        • 20.7. The PivotField Object
          • 20.7.1. AutoShow-Related Members
          • 20.7.2. Sorting Pivot Fields
          • 20.7.3. The Fundamental Properties
            • 20.7.3.1. Function property
            • 20.7.3.2. NumberFormat property
            • 20.7.3.3. Orientation property
            • 20.7.3.4. Position property
          • 20.7.4. Selecting Ranges
            • 20.7.4.1. DataRange property
            • 20.7.4.2. LabelRange property
          • 20.7.5. Dragging Pivot Fields
          • 20.7.6. Name, Value, and SourceName Properties
          • 20.7.7. Grouping
          • 20.7.8. Data Field Calculation
            • 20.7.8.1. Calculation property
            • 20.7.8.2. Calculations not requiring a BaseField/BaseItem
            • 20.7.8.3. Calculations requiring a BaseField/BaseItem
          • 20.7.9. CurrentPage Property
          • 20.7.10. DataType Property
          • 20.7.11. HiddenItems and VisibleItems Properties
          • 20.7.12. MemoryUsed Property
          • 20.7.13. ServerBased Property
          • 20.7.14. ShowAllItems Property
          • 20.7.15. Subtotals Method
        • 20.8. The PivotCache Object
          • 20.8.1. Refreshing a Pivot Cache
          • 20.8.2. MemoryUsed Property
          • 20.8.3. OptimizeCache Property
          • 20.8.4. RecordCount Property
          • 20.8.5. SourceData Property
          • 20.8.6. Sql Property
        • 20.9. The PivotItem Object
          • 20.9.1. DataRange Property
          • 20.9.2. LabelRange Property
          • 20.9.3. IsCalculated Property
          • 20.9.4. Name, Value, and SourceName Properties
          • 20.9.5. Position Property
          • 20.9.6. RecordCount Property
          • 20.9.7. ShowDetail Property
          • 20.9.8. Visible Property
        • 20.10. PivotCell and PivotItemList Objects
          • 20.10.1. ColumnItems, RowItems, and DataField Properties
          • 20.10.2. CustomSubtotalFunction Property
          • 20.10.3. PivotCellType Property
          • 20.10.4. PivotTable, PivotField, and PivotItem Properties
        • 20.11. Calculated Items and Calculated Fields
        • 20.12. Example: Printing Pivot Tables
          • 20.12.1. Create the UserForm
            • 20.12.1.1. List box
            • 20.12.1.2. Print button
            • 20.12.1.3. Cancel button
          • 20.12.2. Create the Code Behind the UserForm
            • 20.12.2.1. The Declarations section
            • 20.12.2.2. Cancel button code
            • 20.12.2.3. Print button code
            • 20.12.2.4. The Form's Initialize event
            • 20.12.2.5. PrintPTs procedure
      • 21. The Chart Object
        • 21.1. Chart Objects and ChartObject Objects
        • 21.2. Creating a Chart
          • 21.2.1. Creating Chart Sheets
          • 21.2.2. Creating Embedded Charts
          • 21.2.3. An Example of Chart Creation
          • 21.2.4. Z-Order and ChartObject Objects
        • 21.3. Chart Types
          • 21.3.1. ChartType property
            • 21.3.1.1. ApplyCustomType method
        • 21.4. Children of the Chart Object
        • 21.5. The Axes Collection
        • 21.6. The Axis Object
          • 21.6.1. AxisGroup Property
          • 21.6.2. Axis Titles and Their Formatting
            • 21.6.2.1. HasTitle property (R/W Boolean)
            • 21.6.2.2. The Border property and the Border object
          • 21.6.3. CategoryNames Property
          • 21.6.4. CategoryType Property and BaseUnit Property
          • 21.6.5. Crosses and CrossesAt Properties
          • 21.6.6. Display Units
          • 21.6.7. Gridline-Related Properties and the Gridline Object
          • 21.6.8. Position- and Dimension-Related Properties
          • 21.6.9. Tick Mark-Related Properties
            • 21.6.9.1. The TickLabels object
          • 21.6.10. Units-Related Properties
          • 21.6.11. ReversePlotOrder Property
          • 21.6.12. Type Property
        • 21.7. The ChartArea Object
        • 21.8. The ChartGroup Object
          • 21.8.1. UpBars and DownBars
          • 21.8.2. DropLines
          • 21.8.3. HiLoLines
          • 21.8.4. SeriesCollection and Series Objects
          • 21.8.5. SeriesLines
        • 21.9. The ChartTitle Object
        • 21.10. The DataTable Object
        • 21.11. The Floor Object
        • 21.12. The Legend Object
          • 21.12.1. The LegendEntry Object
          • 21.12.2. The LegendKey Object
        • 21.13. The PageSetup Object
        • 21.14. The PlotArea Object
        • 21.15. The Series Object
          • 21.15.1. Adding a New Series
          • 21.15.2. The DataLabel Object
          • 21.15.3. The Point Object
            • 21.15.3.1. Explosion property
            • 21.15.3.2. MarkerSize and MarkerStyle
        • 21.16. Properties and Methods of the Chart Object
          • 21.16.1. ChartWizard Method
          • 21.16.2. Export Method
          • 21.16.3. PrintOut Method
        • 21.17. Example: Scrolling Through Chart Types
        • 21.18. Example: Printing Embedded Charts
          • 21.18.1. Create the UserForm
            • 21.18.1.1. List box
            • 21.18.1.2. Print button
            • 21.18.1.3. Cancel button
          • 21.18.2. Create the Code Behind the UserForm
            • 21.18.2.1. The Declarations section
            • 21.18.2.2. Cancel button code
            • 21.18.2.3. Print button code
            • 21.18.2.4. The Form's Initialize event
            • 21.18.2.5. The PrintCharts procedure
        • 21.19. Example: Setting Data Series Labels
      • 22. Smart Tags
        • 22.1. What Are Smart Tags?
        • 22.2. SmartTagRecognizer Object
        • 22.3. SmartTag Object
        • 22.4. SmartTagAction Object
        • 22.5. SmartTagOptions Object
    • IV. Appendixes
      • A. The Shape Object
        • A.1. What Is the Shape Object?
        • A.2. Z-Order
        • A.3. Creating Shapes
          • A.3.1. The TextFrame Object
          • A.3.2. The FillFormat Object
          • A.3.3. Examples
        • A.4. Diagram, DiagramNode, and DiagramNodeChildren Objects
      • B. Getting the Installed Printers
      • C. Command Bar Controls
        • C.1. Built-in Command-Bar Controls
      • D. Face IDs
      • E. Programming Excelfrom Another Application
        • E.1. Setting a Reference to the Excel Object Model
        • E.2. Getting a Reference to the Excel Application Object
          • E.2.1. An Alternative Approach
            • E.2.1.1. The CreateObject function
            • E.2.1.2. The GetObject function
            • E.2.1.3. No object library reference
      • F. High-Level and Low-Level Languages
        • F.1. BASIC
        • F.2. Visual Basic
        • F.3. C and C++
        • F.4. Visual C++
        • F.5. Pascal
        • F.6. FORTRAN
        • F.7. COBOL
        • F.8. LISP
      • G. New Objects in Excel XP
        • AllowEditRange Object
        • AutoRecover Object
        • CalculatedMember Object
        • CellFormat Object
        • CustomProperty Object
        • Diagram, DiagramNode and DiagramNodeChildren Objects
        • Error Object
        • ErrorCheckingOptions Object
        • Graphic Object
        • IRTDServer and IRTDUpdateEvent Objects
        • PivotCell and PivotItemList Objects
        • Protection Object
        • RTD Object
        • SmartTag Related Objects
        • Speech Object
        • SpellingOptions Object
        • Tab Object
        • UsedObjects Object
        • UserAccessList andUserAccess Objects
        • Watch Object
    • Index
    • Colophon
    • SPECIAL OFFER: Upgrade this ebook with OReilly

Dodaj do koszyka Writing Excel Macros with VBA. 2nd Edition

Code, Publish & WebDesing by CATALIST.com.pl



(c) 2005-2024 CATALIST agencja interaktywna, znaki firmowe należą do wydawnictwa Helion S.A.