Excel: Learning VBA

Contents

• Introduction Introduction

  • Extend the capabilities of Excel using VBA

    26s
  • (Locked)
    What you should know before starting

    1m 10s
• 1. Introducing Visual Basic for Applications 1. Introducing Visual Basic for Applications

  • (Locked)
    Introduce object-oriented programming

    3m 2s
  • (Locked)
    Examine the Excel object model

    4m 14s
  • (Locked)
    Work in the Visual Basic Editor

    6m 27s
  • (Locked)
    Set VBA project properties

    4m 28s
  • (Locked)
    Create, export, and delete code modules

    5m 54s
  • (Locked)
    Create a subroutine

    3m 28s
  • Create a function

    5m 2s
  • (Locked)
    Add comments to your code

    4m 47s
  • Run a VBA procedure

    5m 20s
  • (Locked)
    Add code to a recorded macro

    3m 48s
• 2. Defining Variables, Constants, and Calculations 2. Defining Variables, Constants, and Calculations

  • (Locked)
    Introduce Excel VBA data types

    4m 5s
  • (Locked)
    Declare variables and require declaration before use

    5m 27s
  • (Locked)
    Manage variable scope

    3m 50s
  • (Locked)
    Define static variables and constants

    5m 42s
  • Create a calculation using mathematical operators

    5m 10s
  • (Locked)
    Define arrays

    7m 10s
  • Define and use object variables

    3m 3s
  • (Locked)
    Streamline code references using With…End With statements

    4m 40s
  • (Locked)
    Challenge: Define variables, constants, and calculations

    2m 5s
  • (Locked)
    Solution: Define variables, constants, and calculations

    3m 13s
• 3. Adding Logic to Your VBA Code 3. Adding Logic to Your VBA Code

  • Repeat a task using a For…Next loop

    5m 6s
  • (Locked)
    Step through all items of a collection using a For…Each loop

    4m 37s
  • (Locked)
    Repeat a task using a Do loop

    5m 47s
  • (Locked)
    Execute code conditionally using an If…Then statement

    6m 48s
  • (Locked)
    Select which action to take using a Case statement

    3m 42s
  • (Locked)
    Challenge: Add logic to your code

    2m 52s
  • (Locked)
    Solution: Add logic to your code

    4m 40s
• 4. Debugging Your VBA Code 4. Debugging Your VBA Code

  • (Locked)
    Manage errors using On Error statements

    6m 8s
  • (Locked)
    Step through a subroutine or function

    6m 2s
  • (Locked)
    Set breakpoints in your code

    3m 47s
  • (Locked)
    Verify output using the Immediate window

    5m 10s
  • (Locked)
    Watch a value in a routine

    4m 10s
  • (Locked)
    Challenge: Debug your VBA code

    3m 38s
  • (Locked)
    Solution: Debug your VBA code

    4m 1s
• 5. Manage Workbook Elements and Data in VBA 5. Manage Workbook Elements and Data in VBA

  • (Locked)
    Write a value to a cell

    4m 29s
  • (Locked)
    Cut, copy, and paste cell data

    6m 51s
  • (Locked)
    Find values in cells

    5m 7s
  • (Locked)
    Refer to cells using the OFFSET property

    5m 1s
  • (Locked)
    Concatenate text strings

    4m 4s
  • (Locked)
    Return part of a string

    6m 15s
  • (Locked)
    Manage worksheets with VBA

    8m 30s
  • (Locked)
    Manage workbooks with VBA

    6m 41s
  • (Locked)
    Challenge: Manage workbook elements and data in VBA

    2m 53s
  • (Locked)
    Solution: Manage workbook elements and data in VBA

    3m 8s
• 6. Adding Advanced Elements to Your VBA Code 6. Adding Advanced Elements to Your VBA Code

  • (Locked)
    Turn off screen updating when you run a macro

    4m 21s
  • (Locked)
    Use worksheet functions in a macro

    3m 12s
  • (Locked)
    Acquire values using an input box or message box

    6m 55s
  • (Locked)
    Call a subroutine from another subroutine

    3m 46s
  • (Locked)
    Challenge: Add advanced elements to your workbook

    3m 35s
  • (Locked)
    Solution: Add advanced elements to your workbook

    4m 1s
• 7. Using Excel Events in Your VBA Code 7. Using Excel Events in Your VBA Code

  • (Locked)
    Run a procedure when you open, close, or save a workbook

    5m 35s
  • (Locked)
    Run a procedure when a cell range changes

    5m 37s
  • (Locked)
    Trigger a procedure using a specific key sequence

    3m 48s
  • (Locked)
    Challenge: Use Excel events in your VBA code

    3m 9s
  • (Locked)
    Solution: Use Excel events in your VBA code

    3m 30s
• Conclusion Conclusion

  • (Locked)
    Further resources

    1m 14s