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
MySQL Stored Procedure Programming
Block Structure of Stored Programs
Conclusion
Conclusion
Basic SQL Tuning
How Fast Is the Stored Program Language?
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Introduction to Kanban
Developing a Kanban Design
Initial Startup and Common Pitfalls
Appendix E EOQ vs. Kanban
Appendix H Case Study 1: Motor Plant Casting Kanban
Network Security Architectures
Everything Is a Weapon
Identity Technology Guidelines
Expected Threats
Appendix C. Sample Security Policies
Password Policy
C++ How to Program (5th Edition)
Introduction
Case Study: Payroll System Using Polymorphism
Comparing strings
Appendix C. Fundamental Types
E.6. Program Termination with exit and atexit
Cisco CallManager Fundamentals (2nd Edition)
Summary
Media Processing Overview
Summary
Summary
SCCP Call Signaling
Java Concurrency in Practice
Handling Abnormal Thread Termination
Configuring ThreadPoolExecutor
Why are GUIs Single-threaded?
Deadlock
Nonblocking Algorithms
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