Refer to cells using the OFFSET function

Contents

• Introduction Introduction

  • Dive into using VBA in Excel

    26s
  • What you should know

    1m 26s
• 1. Visual Basic for Applications 1. Visual Basic for Applications

  • Introduce object-oriented programming

    2m 28s
  • Examine the Excel object model

    4m 44s
  • Work in the Visual Basic Editor

    5m 55s
  • Set VBA project properties

    3m 55s
  • Create, export, and delete code modules

    4m 48s
  • Create a subroutine

    4m 44s
  • Create a function

    4m 57s
  • Add comments to your code

    3m
  • Run a VBA routine

    6m 8s
  • Add code to a recorded macro

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

  • Introduce Excel VBA data types

    5m 18s
  • Declare variables and require declaration before use

    5m
  • Manage variable scope

    3m 54s
  • Define static variables and constants

    4m 26s
  • Create a calculation using mathematical operators

    4m 32s
  • Define arrays

    7m
  • Define and use object variables

    3m 29s
  • Streamline code references using With…End With statements

    4m 6s
• 3. Adding Logic to Your VBA Code 3. Adding Logic to Your VBA Code

  • Repeat a task using a For...Next loop

    3m 37s
  • Step through all items of a collection using a For...Each loop

    3m 27s
  • Repeat a task using a Do loop

    5m 4s
  • Perform a task when conditions are met using an If...Then statement

    5m 12s
  • Select which action to take using a Case statement

    3m 9s
• 4. Debugging Your VBA Code 4. Debugging Your VBA Code

  • Manage errors using On Error statements

    6m 10s
  • Step through a subroutine or function

    6m 3s
  • Set breakpoints in your code

    3m 32s
  • Verify output using the Immediate window

    5m 41s
  • Watch a value in a routine

    3m 30s
• 5. Managing Workbook Elements and Data in VBA 5. Managing Workbook Elements and Data in VBA

  • Write a value to a cell

    4m 9s
  • Cut, copy, and paste cell data

    5m 6s
  • Find values in cells

    4m 35s
  • Refer to cells using the OFFSET function

    3m 31s
  • Concatenate text strings

    5m 7s
  • Return part of a string

    3m 57s
  • Manage worksheets with VBA

    7m
  • Manage workbooks with VBA

    5m 7s
• 6. Adding Advanced Elements to Your Workbook 6. Adding Advanced Elements to Your Workbook

  • Turn off screen updating when you run a macro

    3m 8s
  • Use worksheet functions in a macro

    2m 48s
  • Acquire values using an input box or message box

    5m 48s
  • Call a subroutine from another subroutine

    2m 57s
• 7. Using Excel Events in Your VBA Code 7. Using Excel Events in Your VBA Code

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

    5m 28s
  • Run a procedure when a cell range changes

    4m 28s
  • Trigger a procedure using a specific key sequence

    2m 41s
• 8. Putting It All Together 8. Putting It All Together

  • Apply techniques in a capstone project

    5m 1s
• Conclusion Conclusion

  • Further information

    1m 19s