Programming with VBA Excel

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

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.

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

Classroom Courses