Excel Programming with VBA

Request an offer for delivery of this course

Course duration

Course Benefits

  • Understand how the Visual Basic editor works in Excel.
  • Learn to work with the VBA object model.
  • Learn to work with VBA object variables.
  • Learn to work with string variables.
  • Learn to work with date variables.
  • Learn to work with numeric variables.
  • Learn to use the selection structure.
  • Learn to use the Select Case statement and the MsgBox function.
  • Learn to work with the repetition structure.
  • Learn to work with option button, check box, and list box controls.
  • Learn to use Automation.
  • Learn to trap errors.
Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.

Microsoft Silver Certified Partner

Course Outline

  1. Introducing the Visual Basic Editor
    1. Using the Visual Basic Editor
  2. Working with the Object Model
    1. Using the Object Model
  3. Working with the Object Variables
    1. Creating and Using Object Variables
  4. Working with String Variables
    1. Using String Variables
  5. Working with Date Variables
    1. Discussing Date Variables
    2. Using Date Variables
  6. Working with Numeric Variables
    1. Discussing Numeric Variables
    2. Using Numeric Variables
  7. Using the Selection Structure
    1. Discussing the Selection Structure
    2. Using the Selection Structure
  8. Using the Select Case Statement and the MsgBox Function
    1. Understanding Select Case Statement and MsgBox Function
    2. Using the Select Case Statement and the Msgbox Function
  9. Working with the Repetition Structure and the With Statement
    1. Understanding the Repetition Structure and the With Statement
    2. Using the Repetition Structure and the With Statement
  10. Advanced Repetition Structure and String Functions
    1. Using the String Repetition Structure and String Functions
  11. Working with Option Button, Check Box, and List Box Controls
    1. Discussing the Dialog Box Controls
    2. Using the Option Button, Check Box, and List Box Controls
  12. Automation
    1. Understanding the Automation Process
    2. Using Automation
  13. Advanced Automation and Error Trapping
    1. Discussing Automation and Error Trapping
    2. Using Automation and Error Trapping

Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Since its founding in 1995, InterSource has been providing high quality and highly customized training solutions to clients worldwide. With over 500 course titles constantly updated and numerous course customization and creation possibilities, we have the capability to meet your I.T. training needs.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.