Creating & Editing Macros in Excel 2019 for Windows

Excel 2019 (Windows)    |    Expert
  • 10 videos | 42m 46s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 250 users Rating 4.4 of 250 users (250)
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

  • 3m 35s
    From the Visual Basic editor you can get a complete view of your macros and their components. Discover how to identify the key macro components such as procedure, sub procedures and comments in Excel 2019. FREE ACCESS
  • 3m 39s
    In the Visual Basic editor your macros are contained within the project component modules. You can add modules, rename modules and start adding code to your modules within Excel 2019. FREE ACCESS
  • Locked
    3.  Inserting procedures in Excel 2019 for Windows
    3m 42s
    In Excel 2019, modules are used to store procedures. In the Visual Basic editor you can manually insert procedures or use the insert tool to quickly insert public and private procedures in your modules. FREE ACCESS
  • Locked
    4.  Writing code in Visual Basic within Excel 2019 for Windows
    6m 15s
    With Visual Basic in Excel 2019 you can write your own code from scratch. See how to add properties, methods and comments. You can also edit your code formatting by using the edit tools. FREE ACCESS
  • Locked
    5.  Using Variables & Constants in Excel 2019 for Windows
    3m 27s
    When creating macros in Excel 2019, you will need to know how to declare and assign variables. You'll also see how to insert constants to save time when writing code in Visual Basic. FREE ACCESS
  • Locked
    6.  Using Objects in Excel 2019 for Windows
    5m 19s
    Visual Basic works with an object model program. You can easily insert objects, browse the object library and create object collections with Excel 2019. FREE ACCESS
  • Locked
    7.  Using Operators in Excel 2019 for Windows
    3m 21s
    You can insert operators into your macros to perform calculations. It's also possible to insert comparison and logical operators to perform calculations if certain criteria are met. See how to insert and test operators in Excel 2019. FREE ACCESS
  • Locked
    8.  Execute actions under conditions in Excel 2019 for Windows
    3m 35s
    You can insert procedures with conditions using If, Then, and Else to return specific values. Excel 2019 also gives you the possibility to work with cases by inserting the CaseValue procedure. FREE ACCESS
  • Locked
    9.  Creating Events in Excel 2019 for Windows
    5m 21s
    Event procedures enable you to interact with objects. You can rename spreadsheets and create reminders with the event procedures available in Excel 2019. FREE ACCESS
  • Locked
    10.  Managing Errors in Excel 2019 for Windows
    4m 33s
    There are three types of errors that can occur in macros: syntax, runtime and logic errors. See how to identify and correct macro errors with Excel 2019. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Book Excel 2021 / Microsoft 365 Programming By Example
Course Creating and editing macros in Excel 365
Rating 4.5 of 380 users Rating 4.5 of 380 users (380)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Finding & Grouping Data in Excel 2019 for Windows
Rating 4.5 of 482 users Rating 4.5 of 482 users (482)
Course Six Sigma Black Belt: Fundamentals of Lean and Six Sigma and their Applications
Rating 4.3 of 843 users Rating 4.3 of 843 users (843)
Course Creating & Saving Workbooks in Excel 2019 for Windows
Rating 4.4 of 855 users Rating 4.4 of 855 users (855)