Flylib.com
Absolute Beginners Guide to VBA
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
Year: 2003
Pages: 146
Authors:
Paul McFedries
BUY ON AMAZON
Absolute Beginner s Guide to VBA
Table of Contents
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 TrueFalse 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
index_SYMBOL
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
Year: 2003
Pages: 146
Authors:
Paul McFedries
BUY ON AMAZON
Adobe After Effects 7.0 Studio Techniques
Putting Masks in Motion
Optimizing After Effects
Color Correction
Film and Video Looks
Creating a Look with Color
A Practitioners Guide to Software Test Design
Equivalence Class Testing
State-Transition Testing
Section II - White Box Testing Techniques
Section IV - Supporting Technologies
When to Stop Testing
Data Structures and Algorithms in Java
Encapsulation
Problems
Reference Types
Vocabulary
Vocabulary
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
How to Reference $ Fields
Display Documents in a View by Year and Month
Retrieve All Columns in a View
Using Static Popups to Display Help Messages
About the Companion Web Site
Microsoft WSH and VBScript Programming for the Absolute Beginner
Overview of the Windows Script Host
Processing Collections of Data
Handling Script Errors
Using the Windows Registry to Configure Script Settings
Appendix C Whats on the CD-ROM?
Programming .Net Windows Applications
Building and Running
Forms Inheritance
Exceptions
Assert Yourself
Build Configurations
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies