Programming with VBA Excel

Inter-company training

Who is the training for?

All public

Duration

3,00 day(s)

Language(s) of service

EN FR

Prerequisites

Experience in the use of Microsoft Office system products, particularly in Excel, is preferred. No previous programming experience is required.

Goals

In this hands-on course, you will learn the basics of programming and VBA from the ground up. You will develop the skills needed to automate repetitive tasks, design interfaces for users and increase performance to improve user productivity.

Contents

Introduction to VBA

  • Language type
  • Scope of application
  • VBE Environment
  • Program Scope

Macros

  • Recording and running macros
  • Limitations of recorded macros
  • Improved automatically generated VBA code

Introduction to programming

  • Structure of a macro
  • Variables and data types
  • Constants
  • Conditional structures (IF, CASE)
  • Loops (WHILE, FOR)
  • Objects (Methods, Properties, Events)
  • Excel objects (workbook, sheet, etc.)
  • Collections

Debugging

  • Step by step
  • Immediate window
  • Breakpoints

Procedures and Functions

  • Differences
  • Usage
  • Arguments

Message boxes

  • Information boxes
  • Input boxes

Creating a user interface

  • ActiveX controls (TextBox, Combobox, Checkbox, ListBox, etc.)
  • Event Programming

Error handling

  • The GoTo Error structure.
  • Error handling in code.
  • Error Resume.

Exporting code

  • Creation et insertion of addins.

Security

  • The dangers of macros.
  • Security levels.
  • Code protection.

Tips & tricks from Professionals

Mode of organisation

Classroom Courses

These courses might interest you

EN
Day
On request
Software - Office software - Word processing software - Visio software