Excel Macros and VBA

Excel VBA and Macros

Course Description

This course is designed for professionals who want to start exploring the use of Excel Macros and VBA as powerful tools in creating reports, forms, and dashboards.

The trainer will start by explaining the objects, properties, and methods. The course will introduce a few programming basics to ensure the participants know the terms used, such as variables, constants, and operators.

The course will explain in detail how the different Excel objects can be used to create powerful automated tools that will help the users in their daily life.
This four-day course will start at the basics as it will help the participants understand how Workbooks, Worksheets, and Range objects interact. As the lesson progresses, many exercises and materials can be used to support the participants during and after the course.

Course Objectives

At the end of this four-day course, participants will learn the following:

• Learn Objects, Properties, Methods
• Explore the Visual Basic for Application Interface
• Introduce Programming Basics
• Introduce different types of Objects such as Workbooks, Worksheets, and Range
• Learn how to use Conditional Statements
• Explore the use of Loops
• Discuss Other Useful Objects
• Introduce Functions and Events
• Explore and use Forms

Course Modules

Lesson 1  – Objects, Methods, Properties

1. Objects
2. Methods
3. Properties

Lesson 2 – Visual Basic for Application (VBA) Environment

1. Sheets
2. Modules and Functions
3. User Forms
4. Tools and Ribbons
5. Variables
6. Constants

Lesson 3 – Useful Objects and their Properties and Methods

1. Application
2. Workbooks
3. Worksheets

Lesson 4 – Ranges

1. Range Objects
2. Cells Property

Lesson 5 –  Conditions

1. If-Then-Else-End If
2. Select-Case-End Select

Lesson 6 – Looping

1. For-Next
2. With-End With

Lesson 7 – Message Box, Input Box, and Other Useful Objects

1. Message Box
2. Input Box
3. Other Useful Objects

Lesson 8  – Arrays

1. Introduction to Arrays
2. Lower and Upper Bounds
3. Dynamic Arrays

Lesson 9 – Functions and Events

1. Introduction to Functions
2. Introduction to Events

Lesson 10 – User Forms

1. Buttons
2. Text Box
3. Input Box
4. List Box
5. Combo Box