The Excel VBA Programming Course – Edu Connect | Shaping Tomorrow's Leaders Today

About Course

The Excel VBA Programming Course is designed to equip you with essential skills in Excel Visual Basic for Applications (VBA), Microsoft’s powerful programming language. This course offers a comprehensive introduction to object-oriented programming, enabling you to automate tasks, enhance productivity, and create dynamic Excel solutions. Through practical lessons, you will learn how to record and save macros, work with the VBA editor, use variables and procedures, and apply programming logic with loops and IF statements. You will also explore advanced features like error handling, user-defined functions, and creating custom forms. With hands-on assignments, this course prepares you to solve real-world challenges using Excel VBA.

Understand and apply object-oriented programming principles in Excel VBA, including the ability to record, save, and manipulate Macros using the VBA editor.
Develop proficiency in handling programming constructs such as variables, procedures, loops, IF statements, and error handling to automate tasks and enhance productivity in Excel.
Design and implement custom forms and user-defined functions using VBA, applying these skills in practical assignments to solve real-world problems efficiently.

Course Content

Introduction

Course Overview

00:00
What is VBA?

00:00
Object Orientated Programming

00:00

Using Macros

VBA Editor

Variables and Procedures

Module Introduction

00:00
Variables

00:00
What are Procedures

00:00
What are Procedures? – Part 1

00:00
What are Procedures? – Part 2

00:00
What are Procedures? – Part 3

00:00
Message Boxes

00:00
Input Box – Part 1

00:00
Input Box – Part 2

00:00
Basic Navigation

00:00
Sheets

00:00
Cell Navigation

00:00
Advanced Sheets

00:00
Offset

00:00

Loops and IF Statements

Error Handling

User Defined Functions

Creating Forms

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Introduction

Course Overview

What is VBA?

Object Orientated Programming

Using Macros

Macros Initial Setup

Recording a Macro

Saving a Macro

VBA Editor

Launching VBA

VB Editor

Custom Menu

Naming Projects

Modules

Code Window

Comments

Variables and Procedures

Module Introduction

Variables

What are Procedures

What are Procedures? – Part 1

What are Procedures? – Part 2

What are Procedures? – Part 3

Message Boxes

Input Box – Part 1

Input Box – Part 2

Basic Navigation

Sheets

Cell Navigation

Advanced Sheets

Offset

Loops and IF Statements

Module Introduction

Operators

Using Variables

What is Automation

For Loops

Do Loops

IF Statements – Part 1

IF Statements – Part 2

Select Case

Error Handling

Debugging

User Defined Functions

UDF’s

Creating Forms

Form Controls

Building the Form

Initialise the Form

Command Buttons – Part 1

Command Buttons – Part 2

Student Ratings & Reviews

Quick Links

Sustainability

Support