Introduction
- Introduction
Macro Development Basics
- Displaying the Developer Tab
- Setting Macro Trust within Excel 2010
- Recording and Running a Macro
- Examining the VBA Editor
VBA Programming Fundamentals
- Reviewing the Excel 2010 Object Model
- Understanding Functions and Procedures
- Understanding Variables and Scope
- Commenting Your Code
- Creating Constants
- Understanding Arguments
Working with Control Structures
- Using If/Then/Else
- Understanding Logical Operators
- Creating a Select/Case Statement
- Creating For/Next Loops
- Creating Do Loops
- Creating While/Wend Loops
Using VBA Functions
- Viewing the Object Browser
- Using the InputBox() Function
- Understanding the MsgBox() Function
- Using String Functions
- Using Date Functions
Creating UserForms
- Designing a Form
- Understanding Different Controls
- Working with Form Properties
Debugging Techniques
- Understand the Difference Between Syntax and Logic Errors
- Using Breakpoints
- Stepping Through Your Macro
- Creating Watches
- Adding Error Traps
Conclusion
- Conclusion
