Creating & Editing Macros
Excel 2019 (Windows)
| Expert
- 10 Videos | 42m 46s
- Includes Assessment
- Earns a Badge
- CPE
- PMI PDU
In Excel 2019 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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Editing Macros Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
identify the key components of a macro
work with modules in the VBA Editor
insert procedures into macro modules
write code in Visual Basic
declare variables and insert constants -
insert objects and create object collections
use operators
execute actions under conditions
create events
manage errors
IN THIS COURSE
-
1.Understanding macros3m 35sUP NEXT
-
2.Working with modules3m 39s
-
3.Inserting procedures3m 42s
-
4.Writing code in Visual Basic6m 15s
-
5.Using Variables & Constants3m 27s
-
6.Using Objects5m 19s
-
7.Using Operators3m 21s
-
8.Execute actions under conditions3m 35s
-
9.Creating Events5m 21s
-
10.Managing Errors4m 33s
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.
