Introduction.
WEEK 1. AT A GLANCE.
1. Getting Started.
Macros and Programming Languages. Why Learn Visual Basic for Applications? Recording A New Macro. Putting It Together: Recording Your First Macro. Macro Source Code. Running Macros. Summary. Workshop.
2. Writing And Editing Simple Macros.
Understanding the Visual Basic for Applications Environment. Editing Macros. Writing New Macros and Procedures. Running a Procedure While Editing. Displaying Messages to a Procedure's User. Understanding Error Messages While Writing, Editing, or Running a Procedure. Printing Your Source Code. Summary. Workshop.
3. Understanding Data Types, Variables, And Constants Examining Visual Basic Data Types. Understanding Variables. Understanding Constants. Getting Data from Your Procedure's User. Summary. Workshop.
4. Operators And Expressions.
Understanding Operators and Expressions. Data Type Compatibility. Visual Basic's Automatic Data Conversions. The Assignment Operator (=). Arithmetic Operators. Comparison Operators. Logical Operators. String Concatenation Operators. Understanding Operator Precedence and Complex Expression Evaluation. Summary. Workshop.
5. Using Visual Basic And Excel Functions.
Understanding Functions. Using Visual Basic for Application's Functions. Using Excel's Functions. Using the Object Browser to Insert Function Calls. Using Functions to Manipulate Strings. Summary. Workshop.
6. Creating And Using Vba Function Procedures And Excel User-Defined Functions.
Understanding Function Procedures and User-Defined Functions. Creating Function Procedures. Using Function Procedures in Visual Basic for Applications. Using the Object Browser to Find Your Function Procedures. Using User-Defined Functions in Excel Worksheets. Designing Function Procedures. Understanding Recursion. Summary. Workshop.
7. Understanding Objects And Collections.
Understanding Objects. Using Objects. Working with Object Collections and Object Containers. Using the Object Browser with Objects, Methods, and Properties. Summary. Workshop.
Week 1. In Review: A Basic Workbook Creation Utility.
WEEK 2. AT A GLANCE.
8. Making Decisions In Visual Basic For Applications.
Understanding VBA's Decision-Making Commands. Making Simple Choices. Making Complex Choices. Unconditional Branching. Ending Procedures, Functions, and Entire Programs Early. Using MsgBox to Let Users Make Choices. Summary. Workshop. Exercises.
9. Repeating Actions In Visual Basic: Loops.
Understanding Looping Commands. Fixed Repetition: The For Loops. Flexible Repetition: The Do Loops. Ending Loops Early. Nesting Loops. Summary. Workshop.
10. Advanced Techniques For Using Data Types And Variables.
Getting Information About Variables and Expressions. Defensive Programming: Preventing Errors Before They Happen. Preserving Variables Between Function and Procedure Calls. Summary. Workshop.
11. Creating Your Own Data Types And Object Classes.
Creating Your Own Data Types. Defining a User-Defined Data Type. Creating Your Own Program Objects. Summary. Workshop.
12. CREATING LIBRARIES AND WHOLE PROGRAMS: MODULAR PROGRAMMING TECHNIQUES.
Using Modules More Effectively. Advanced Scope Rules for Cross-Module Programming. Understanding Structured Programming Techniques. Using Procedure Arguments to Communicate Data Between Procedures. Summary. Workshop.
13. Managing Files With Visual Basic For Applications.
Understanding File Management. Working with File Attributes. Getting or Finding Filenames. Using Excel's Built-In Dialogs to Get Filenames. Working with Disk Drives and Folders. Copying and Deleting Files. Renaming or Moving Files. Getting Information about Files. Summary. Workshop.
14. Arrays.
The Option Base Statement. Declaring Arrays. Using Arrays. Using ReDim with Dynamic Arrays. The LBound and UBound Functions. Using Erase to Clear or Remove Arrays. Using Arrays as Arguments to Procedures and Functions. Sorting Arrays. Searching Arrays. Summary. Workshop.
Week 2. In Review: Enhancing The Workbook Creation Utility.
WEEK 3. AT A GLANCE.
15. Debugging And Testing Vba Code.
Basic Types of Program Bugs. Using the Break Mode. Using the Step Into Command. Using the Step Over Command. Using the Step Out and Run To Cursor Commands. Understanding and Using Watched Variables. Tracing Procedure Calls. Using the Immediate Window. Summary. Workshop.
16. Creating Custom Dialog Boxes.
Understanding User Forms. Understanding Controls. Using Forms to Create Custom Dialog Boxes. Displaying User Forms with VBA. Using VBA with Controls on a Form. Summary. Workshop.
17. Menus And Toolbars.
Understanding Command Bars. Command Bar Object Methods and Properties. Understanding Built-In and Custom Command Bars. Command Bar Control Objects, Methods, and Properties. Managing Custom and Built-In Command Bars. Managing Command Bar Controls. Putting It Together: A Menu-type Command Bar. Putting It Together: A Toolbar-type Command Bar. Summary. Workshop.
18. Error Handling.
Strategies for Error Handling. The On Error GoTo Statement. The Resume Statement. Finding the Runtime Error's Type, Message, and Location. Forcing Runtime Errors and Creating User-Defined Error Codes: The Error Statement. Using the Err Object. Putting It Together: Examples of Error Handling. Summary. Workshop.
19. Controlling Excel With Vba.
Working with Workbook Objects. Working with Worksheet Objects. Returning a Worksheet Object. Methods That Return Range Objects. Working with Cells and Ranges. Summary. Workshop.
20. Working With Other Applications.
What Is Automation and OLE? Looking Up an Object's Class Type. Adding Linked and Embedded Objects. Working with Linked and Embedded Objects. Using Automation. Accessing DLLs from Visual Basic for Applications. Working with Applications that Don't Support Automation or OLE. Summary. Workshop.
21. Using Event Procedures And Add-Ins.
What Are Events and Event Procedures? Working with Application Object Events. Working with Excel Object Events. Working with Excel's Event-Related Properties and Methods. Working with Add-In Applications. Summary. Workshop.
Week 3. In Review: Utilities Add-In Module And Customized Workbook Class.
Appendix A. Answers.
Index.
