VBA programming

Course audience:

The course is intended for professionals who have already worked with previous versions of Microsoft Excel, use the application in their work, and want to deepen their knowledge and skills in Excel.

The price is per group.

Course objectives:

• Teach the basics of programming.
• Introduce the VBA development environment.
• Learn how to write code in VBA.
• Develop error handling and program debugging skills.
• To introduce object-oriented programming (OOP).
• Learn how to work with custom forms and controls.
• Learn how to create macros for Excel and integrate with other Office programs.

Course program:

Module 1: Programming Basics

• Introduction to programming languages.
• Development environment: what it is and how it works.
• Programs, procedures, functions.
• Variables and their types.
• Loops and conditional operators.
• Fundamentals of object-oriented programming (OOP).

Module 2: Introduction to Visual Basic and VBA

• What is Visual Basic and VBA.
• Features and areas of application of the language.
• VBA development environment.
• Configuring Excel to work with VBA.
• Macros and VBA: creating and saving projects.
• Program execution.

Module 3: Basics of Writing VBA Code

• Variable declarations and their scope.
• Data types and their conversion.
• Constants and working with arrays.
• Overall rating:

  {"hints":["bad","poor","regular","good","gorgeous"]}

  Send

  * The email will not be published on the website.