I. GETTING STARTED WITH VBA. 1. Recording Your First Macro.
What Is a Macro? Recording a VBA Macro. 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. 3. Understanding Program Variables.
Declaring Variables. Avoiding Variable Errors. Variable Data Types. Using Array Variables. Working with Constants. 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. 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. 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.
II. PUTTING VBA TO WORK. 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. 8. Programming Excel.
Excels Application Object. Manipulating Workbook Objects. Dealing with Worksheet Objects. Working with Range Objects. 9. Programming PowerPoint.
PowerPoints Application Object. PowerPoints Presentation Object. Working with PowerPoint Slide Objects. Dealing with Shape Objects. Operating a Slide Show. 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. 11. Programming Outlook Email.
Working with Outlook Folders. Working with Email Messages. Sending a Message. Working with Attachments. Programming Outlook from Other Applications.
III. GETTING THE MOST OUT OF VBA. 12. Interacting with the User.
Programming Sounds. Displaying Information to the User. Getting Input from the User. 13. Creating Custom VBA Dialog Boxes.
Adding a Form to Your Project. Changing the Forms Design-Time Properties. Working with Controls. Handling Form Events. Types of Form Controls.Using a Form in a Procedure. 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. 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.
IV. APPENDIXES. Appendix A. VBA Statements. Appendix B. VBA Functions.