Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com
Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog (All Modalities)

Item IDCourse Title and DescriptionPricePerLength
EVB201iIntroduction to Excel VBA295.00Student6.0 hrs
 Introduction to VBA programming in Excel. Covers variables, data types, control structures, object oriented concepts, debugging, etc. Students should already be proficient in Excel.

 
Session 1VBA Basics 
 
  • Visual Basic Editor - Visual Basic for Applications, Object Programming, The Object Browser
  • Object Programming - Properties, Methods, Events
  • The Object Browser - Using the Object Browser
  • Programming Basics - Variables, Data Types, Operators, Interaction functions, Scope

 
Session 2Using VBA 
 
  • Control structures - If, Select, Loops
  • Custom Dialogs - Forms, Controls, Event Handlers
  • Debugging - Errors, Debugging, Breakpoints, Watch Lists, Step Into, Immediate Window, Locals Window
  • On Error - Using On Error