Excel 365 VBA - Expert

Overview

About this course

Self-paced lessons on VBA in Excel 365: variables, conditional logic, strings, loops, procedures and automating real tasks.

Curriculum

Curriculum

10 modules

Introduction

Adding the Developer Toolbar
Understanding the VBA Editor
Recording a Macro in Personal
Understanding the Elements of the VBA Language
Understanding Methods
Understanding Comments
Working with the Range Property and Worksheet Object
Adding a Macro Button to a Spreadsheet
Working with the ActiveCell Object
Working with the Offset Property

Understanding Variables
Working with Integer Variables
Understanding Option Explicit
Working with Other Variable Types

Working with IF Statements
Working with ELSE
Working with ELSEIF
Understanding Conditional Operators
Working with NOT, AND, and OR
Working with Nested IF
Working with Select Case
Working with WITH and End WITH

Working with Text Strings
Working with LCASE and UCASE Functions
Working with LEN and TRIM Functions
Working with LEFT, RIGHT, and MID Functions

Understanding Loops
Working with For Next Loops
Working with For Each Loops
Working with Cells Property
Working with Do Until Loops
Working with Do While Loops

Calling Sub Procedures
Working with Exit Sub
Working with Message Boxes
Working with Input Boxes
Working with VBA Functions
Working with Object Variable and Set

Understanding and Creating a User Form
Adding Controls to a User Form
Adding Code for a User Form
Launching a User Form from Excel

Getting Started with Debugging
Stepping Through Your Code
Working with Breakpoints
Working with the Immediate Window
Working with the Locals Window
Working with the Err Object

Course Recap

Who it's for

Who it's for

Excel users learning to program.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.