Table of Contents:

• Introduction


• Understanding the Excel Object Model


• Creating Recorded Macros
  
  
  
  • Displaying the Developer Tab
  
  
  • Setting Macro Trust within Excel
  
  
  • Recording a Macro
  
  
  • Running a Macro
  
  
  • Editing a Macro with the Visual Basic Editor
  
  
  
  


• Understanding the Visual Basic Editor
  
  
  
  • Examining the VBA Editor Menu and Toolbar
  
  
  • Setting VBA Editor Options
  
  
  • Reviewing your Project Options
  
  
  • Reviewing the Project Explorer
  
  
  • Reviewing the Properties Window
  
  
  • Working within the Code Window
  
  
  • Viewing the Immediate Window
  
  
  • Viewing the Object Browser
  
  
  
  


• Understanding Programming Basics
  
  
  
  • Understanding Functions and Procedures
  
  
  • Dimensioning Variables
  
  
  • Understanding Object Variables
  
  
  • Understanding Variables and Scope
  
  
  • Commenting your Code
  
  
  • Creating Constants
  
  
  • Manipulating Strings
  
  
  • Understanding Procedure Arguments
  
  
  
  


• Using Visual Basic Functions
  
  
  
  • Using the InputBox() Function
  
  
  • Understanding the MsgBox() Function
  
  
  • Using String Functions
  
  
  • Using Date Functions
  
  
  
  


• Working with Control Structures
  
  
  
  • Using the If/Then/Else Statements
  
  
  • Creating a Select/Case Statement
  
  
  • Using the Case Else Option
  
  
  • Creating For/Next Loops
  
  
  • Creating Do/While Loops
  
  
  • Creating While/Wend Loops
  
  
  
  


• Creating UserForms
  
  
  
  • Designing your First Form
  
  
  • Understanding the Different Controls to Use
  
  
  • Working with the Different UserForm Properties
  
  
  
  


• Debugging your Macros
  
  
  
  • Syntax Errors Vs. Logic Errors
  
  
  • Running your Macro from the VBA Editor
  
  
  • Using Breakpoints
  
  
  • Stepping Through your Macro
  
  
  • Creating Watches
  
  
  • Adding Error Trapping
  
  
  
  


• Conclusion