Creating & Editing Macros in Excel Microsoft 365 for Windows

Excel Microsoft 365 (Windows)    |    Expert
  • 10 Videos | 46m 48s
  • Includes Assessment
  • Earns a Badge
Likes 78 Likes 78
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

  • Playable
    1. 
    Understanding macros in Excel Microsoft 365 for Windows
    3m 27s
    UP NEXT
  • Playable
    2. 
    Working with modules in Excel Microsoft 365 for Windows
    4m
  • Locked
    3. 
    Inserting procedures in Excel Microsoft 365 for Windows
    4m 17s
  • Locked
    4. 
    Writing code in Visual Basic within Excel Microsoft 365 for Windows
    5m 47s
  • Locked
    5. 
    Using Variables & Constants in Excel Microsoft 365 for Windows
    3m 14s
  • Locked
    6. 
    Using Objects in Excel Microsoft 365 for Windows
    6m 38s
  • Locked
    7. 
    Using Operators in Excel Microsoft 365 for Windows
    4m 18s
  • Locked
    8. 
    Execute actions under conditions in Excel Microsoft 365 for Windows
    4m 19s
  • Locked
    9. 
    Creating Events in Excel Microsoft 365 for Windows
    5m 2s
  • Locked
    10. 
    Managing Errors in Excel Microsoft 365 for Windows
    5m 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.

YOU MIGHT ALSO LIKE

Likes 1 Likes 1  
Likes 13 Likes 13  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE