Creating & Editing Macros in Excel Microsoft 365 for Windows

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description

In Excel for Office 365 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document.

In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.

Expected Duration (hours)
0.8

Lesson Objectives

Creating & Editing Macros in Excel Microsoft 365 for Windows

identify the key components of a macro

create, edit and remove modules

insert procedures into your macro modules

write code in Visual Basic

declare variables and insert constants

insert objects and create object collections

insert and test operators

execute actions under conditions

create events

manage and correct macro errors

Course Number:
ds_msex365_23_enus

Expertise Level
Expert