Table of Contents

     
   
  Table of Contents
  Index
                   
Absolute Beginner's Guide to VBA
By Paul  McFedries
 
Publisher : Que
Pub Date : March 09, 2004
ISBN : 0-7897-3076-6
Pages : 384
   
Copyright
      About the Author
      Acknowledgments
      We Want to Hear from You!
      Introduction
      What You Should Know Before Reading This Book
      This Book's Special Features
      Part I:   Getting Started with VBA
          Chapter 1.   Recording Your First Macro
        What Is a Macro?
        Recording a VBA Macro
          Chapter 2.   Writing Your Own Macros
        Displaying the Visual Basic Editor
        Touring the Visual Basic Editor
        Writing Your Own Command Macro
        Running a VBA Macro
        Creating User-Defined Functions with VBA
        Working with Procedures
        Working with Modules
        Shutting Down the Visual Basic Editor
          Chapter 3.   Understanding Program Variables
        Declaring Variables
        Avoiding Variable Errors
        Variable Data Types
        Using Array Variables
        Working with Constants
          Chapter 4.   Building VBA Expressions
        Working with VBA Operators
        Understanding Operator Precedence
        Working with Numeric Expressions
        Working with String Expressions
        Working with Logical Expressions
        Working with Date Expressions
          Chapter 5.   Working with Objects
        The Object Hierarchy
        Working with Object Properties
        Working with Object Methods
        Handling Object Events
        Working with Object Collections
        Assigning an Object to a Variable
        The Is Operator
        Working with Multiple Properties or Methods
        Example: The Application Object
        Example: The Window Object
          Chapter 6.   Controlling Your VBA Code
        Code That Makes Decisions
        Using If...Then to Make True/False Decisions
        Using If...Then...Else to Handle a False Result
        Making Multiple Decisions
        Functions That Make Decisions
        Code That Loops
        Using Do...Loop Structures
        Using For...Next Loops
        Using For Each...Next Loops
        Using Exit For or Exit Do to Exit a Loop
      Part II:   Putting VBA to Work
          Chapter 7.   Programming Word
        Working with Documents
        Working with Text
        The Range Object
        The Selection Object
        The Characters Object
        The Words Object
        The Sentences Object
        The Paragraph Object
          Chapter 8.   Programming Excel
        Excel's Application Object
        Manipulating Workbook Objects
        Dealing with Worksheet Objects
        Working with Range Objects
          Chapter 9.   Programming PowerPoint
        PowerPoint's Application Object
        PowerPoint's Presentation Object
        Working with PowerPoint Slide Objects
        Dealing with Shape Objects
        Operating a Slide Show
          Chapter 10.   Programming Access Databases
        Getting Ready: Two Steps Before You Begin
        Working with Database Records: Opening a Recordset
        Working with a Recordset
        Retrieving Data into Excel
          Chapter 11.   Programming Outlook Email
        Working with Outlook Folders
        Working with Email Messages
        Sending a Message
        Working with Attachments
        Programming Outlook from Other Applications
      Part III:   Getting the Most Out of VBA
          Chapter 12.   Interacting with the User
        Programming Sounds
        Displaying Information to the User
        Getting Input from the User
          Chapter 13.   Creating Custom VBA Dialog Boxes
        Adding a Form to Your Project
        Changing the Form's Design-Time Properties
        Working with Controls
        Handling Form Events
        Types of Form Controls
        Using a Form in a Procedure
          Chapter 14.   Creating Custom Menus and Toolbars
        Assigning Macros to Menu Commands
        Creating Custom Toolbars for Your Macros
        Menus, Toolbars, and VBA
        Understanding Command Bars
        Working with Command Bar Controls
          Chapter 15.   Debugging VBA Procedures
        Trapping Program Errors
        A Basic Strategy for Debugging
        Pausing a Procedure
        Stepping Through a Procedure
        Monitoring Procedure Values
        Using the Immediate Window
        Debugging Tips
      Part IV:   Appendixes
          Appendix A.   VBA Statements
          Appendix B.   VBA Functions
      Index


Absolute Beginner's Guide to VBA
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
Year: 2003
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net