Creating & Editing Macros

Excel 2019 (Windows)
  • 10 Videos | 42m 46s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 23 Likes 23
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.

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

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.

YOU MIGHT ALSO LIKE

COURSE Managing Data
Likes 25 Likes 25  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 53 Likes 53  
Likes 32 Likes 32