Course Outline

Excel 2007 Visual Basic for Applications - Level 2
A one-day, hands-on Visual Basic for Applications course that builds on and expands on concepts covered in the Level 1 class, such as program debugging, error handling and variables. It covers the workbook, worksheet and range objects in detail. The course introduces participants to event members and procedures. Participants create a real-world application employing best practices such as using object variables and creating programs without hard coding cell references. To get the most out of this advanced class, participants should be proficient working in the Visual Basic Editor and should have a basic understanding of the Excel Object Model. 6 hours

Working with Workbook objects

  • Properties, methods and events
  • Creating event handling procedures
  • The Workbooks collection
  • Understanding file Path terms and options
  • Processing multiple files
  • Testing macros

Working with Worksheet objects

  • Properties, methods and events
  • Creating event handling procedures
  • Worksheets, Charts and Sheets collections
  • Processing multiple worksheets

Working with Range objects

  • Properties and methods
  • Declaring Range object variables
  • Range objects as pseudo collections

Communicating with Message and Input boxes

  • Using the MsgBox function
  • Using the InputBox function and Application method

Create an application

  • Consolidate code modules
  • Using Public variables
  • Using Input message boxes
Prerequisites:  Excel VBA Level 1 or equivalent experience.

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