VBA Training - Introduction to VBA

Duration

1 day

Objectives

Provide delegates with a basic familiarity with VBA:

  • Demonstrate the VBA Editor and environment
  • Learn to write simple code in the VBA language
  • Introduce the Excel and Word object models.

Prerequisites

Delegates should have experience of using Word and Excel to an intermediate level.

Topics

  • Introduction: Why VBA?
     
  • The VBA Editor
    • Project Explorer
    • Code Window
    • Immediate Window
    • Object Libraries & the Object Browser
    • A First Procedure
    • Getting Code from Elsewhere
       
  • VBA Code
    • More on Variables & Types
    • Control constructs: conditionals, loops
    • Procedures: subs and functions
    • Comments, etc.
       
  • Application object models
    • Excel: Workbook, Worksheet, Range, etc.
    • Word: Document, Range, Selection, Table, etc.
    • Collections and object references
       
  • Programming Simple Forms
    • Designing a Form
    • Form Properties
    • Form and Control events
    • A simple data input Form
[Roy MacLean - IT] [VBA Training - Introduction to VBA] [VBA Training - Excel VBA] [VBA Training - Access VBA] [VBA Training - Word VBA] [VBA Training - Advanced VBA] [VBA Training - Excel Access Integration] [MS Office Training - Excel Advanced] [DITA Training - Introduction]