Course Outline

Excel 2003 Visual Basic for Applications - Level 1
A one-day, hands-on course covering the basics of using Visual Basic for Applications in Excel. The course covers the Excel Object Model, the Visual Basic Editor, variables, data types and control structures such as loops, conditional structures and with-end with structures. To get the most out of this advanced class, participants should have direct experience working with the Excel macro recorder and with storing and running recorded macros. 6 hours

Introducing Visual Basic for Applications

  • What’s VBA?
  • Macros and VBA
  • Concepts and Terminology

Understanding the Excel Object Model

  • What’s an object model?
  • The object hierarchy
  • Using the object model reference
  • Manipulating Excel objects and collections of objects
  • Object members: methods, properties and events

VBA tools and techniques

  • Modifying recorder-generated code
  • Testing individual statements or groups of statements
  • Re-using code by copying
  • Declaring and using Variables
  • Understanding Excel data types
  • Using Loops: For Each, For Next, Do
  • Using With-End With structures
  • Debugging techniques

Prerequisites:  This course is for advanced Excel users; Excel Recording Macros is highly recommended.

Revised 9/9/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600