Description

A logical continuation of the 'Excel Macros VBA - Level 1' training, this training will allow you to deepen your knowledge of VBA programming, optimize and organize the code to set up and maintain high-performance applications.

Who is this training for ?

For whom ?

User mastering the basics of VBA programming. This course is not aimed at computer scientists.

Prerequisites

Training objectives

Master the VBA programming language. Develop optimized and reliable VBA applications. Optimize and make existing applications more reliable.

Training program

• The fundamentals of VBA programming
  • Objects: ActiveCell, Selection, ActiveSheet, Range...
  • Methods and properties.
  • Collections: Cells, WorkSheets, Charts, WorkBooks.
  • Types of variables, their scope.
  • Passing parameters from one procedure to another.
  • Tests, loops, error handling.
• Create add-in libraries
  • Make a macro accessible from all workbooks (additional macros).
  • Create a library of functions and procedures accessible from all modules (Reference Tools, Addins).
• Develop event procedures
  • Workbook events: open, save, close.
  • Worksheet events: change the contents of a cell, select a cell.
• Build elaborate forms
  • Reminder about controls and their properties.
  • Dynamically manage a drop-down list.
  • Manage cascading lists.
• Control external applications
  • Control Outlook or Word with OLE Automation.
  • Access data with ADO.