Excel VBA Programming - The Complete Guide

Excel VBA Programming - The Complete Guide

Sesong 1
This course is designed for anyone who is looking to automate tasks and procedures in Excel using VBA. With the help of interesting examples and activities, you'll grasp VBA programming fundamentals and learn how to efficiently use objects, properties, and procedures to automate the Microsoft excel workflow.
201917 episoderALLE
Tilgjengelig for kjøp

Episoder

  1. S1 E1 - Getting Started

    22. august 2019
    1 t 13 min
    ALLE
    This episode introduces you to the course and Excel VBA programming. You'll then explore the developer tab, different Excel files, macro security, and visual basic editor interface. You'll also distinguish between absolute and relative references.
    Tilgjengelig for kjøp
  2. S1 E2 - The Fundamentals of the Excel Object Method

    22. august 2019
    52min
    ALLE
    In this episode, you'll discover the role of object-oriented programming in Excel VBA.
    Tilgjengelig for kjøp
  3. S1 E3 - The Visual Basic Editor

    22. august 2019
    50min
    ALLE
    In this episode, you'll go through the features of visual basic editor and learn how to create and delete a procedure.
    Tilgjengelig for kjøp
  4. S1 E4 - Objects and Methods

    22. august 2019
    38min
    ALLE
    This episode will show you how to invoke methods with and without arguments and with multiple arguments. In addition to this, you'll use an object browser to access online documentation and learn different ways to invoke a procedure.
    Tilgjengelig for kjøp
  5. S1 E5 - Variables and Data Types

    22. august 2019
    1 t 20 min
    ALLE
    The episode starts with syntax tips that'll help you to write clean VBA code. You'll then become familiar with variable declarations and get to grips with different data types and mathematical operations.
    Tilgjengelig for kjøp
  6. S1 E6 - Procedures

    22. august 2019
    47min
    ALLE
    In this episode, you'll explore different types of variable and procedure scope and learn how to call a procedure from another procedure. You'll also handle and terminate a procedure and learn how to replace variables with constants.
    Tilgjengelig for kjøp
  7. S1 E7 - Object Deep Dive

    22. august 2019
    1 t 7 min
    ALLE
    This video will help you to understand the Excel object hierarchy in detail and you'll learn how to effectively use different workbook properties and methods such as add, close, move, and delete.
    Tilgjengelig for kjøp
  8. S1 E8 - Range References

    22. august 2019
    1 t 26 min
    ALLE
    In this episode, you'll deep dive into the concepts of Range. You'll explore the value and text properties on the Range object and get to grips with different Range properties such as offset, resize, cells, row, and column. You'll also find out the role of R1C1 notation in VBA.
    Tilgjengelig for kjøp
  9. S1 E9 - Range Actions

    22. august 2019
    1 t 22 min
    ALLE
    This episode will make you familiar with different types of methods and properties such as fill down, replace, text to columns, sort, interior, and autofit.
    Tilgjengelig for kjøp
  10. S1 E10 - Conditionals

    22. august 2019
    46min
    ALLE
    In this episode, you'll become well-versed with conditional statements of Excel VBA such as Boolean expressions, if then statements, elseif and else statements, select cases, AND & OR logical operators, and the Not operator.
    Tilgjengelig for kjøp
  11. S1 E11 - Iteration

    22. august 2019
    1 t 6 min
    ALLE
    In this episode, you'll find out how to use for loop and the step keyword to iterate a certain block of instructions a given number of times. You'll also learn how to use the With-End With construct to overwrite multiple properties on an object. This episode also teaches you how to terminate a for loop.
    Tilgjengelig for kjøp
  12. S1 E12 - Miscellaneous Features

    22. august 2019
    49min
    ALLE
    In this episode, you'll get a solid understanding of the MsgBox method.
    Tilgjengelig for kjøp
  13. S1 E13 - Arrays

    22. august 2019
    42min
    ALLE
    In this episode, you'll explore arrays and their different syntaxes such as lower bound and upper bound. You'll also learn how to initialize arrays within a for loop.
    Tilgjengelig for kjøp
  14. S1 E14 - Functions

    22. august 2019
    1h
    ALLE
    In this episode, you'll deep dive into the VBA functions.
    Tilgjengelig for kjøp
  15. S1 E15 - Debugging

    22. august 2019
    42min
    ALLE
    In this episode, you'll find out some common errors that occur in VBA code and how to catch them using the techniques of error handling.
    Tilgjengelig for kjøp
  16. S1 E16 - Events

    22. august 2019
    47min
    ALLE
    This episode shows you how to handle different events that trigger VBA procedures.
    Tilgjengelig for kjøp
  17. S1 E17 - User Forms

    22. august 2019
    1 t 48 min
    ALLE
    In this episode, you'll learn how to create a user form and configure it with labels, text boxes, buttons, and more.
    Tilgjengelig for kjøp