Creating & Editing Macros
Excel Microsoft 365 (Windows)
| Expert
- 10 Videos | 46m 48s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
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
IN THIS COURSE
-
1.Understanding macros3m 27sUP NEXT
-
2.Working with modules4m
-
3.Inserting procedures4m 17s
-
4.Writing code in Visual Basic5m 47s
-
5.Using Variables & Constants3m 14s
-
6.Using Objects6m 38s
-
7.Using Operators4m 18s
-
8.Execute actions under conditions4m 19s
-
9.Creating Events5m 2s
-
10.Managing Errors5m 46s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
