O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Visual Basic for Applications (VBA) for Microsoft Excel

Video Description

Learn how to do amazing things in Microsoft Excel using Visual Basic for Applications (VBA) in this 9-part video series:

  • Introducing VBA. This first clip in this VBA video series introduces you to the world of Visual Basic for Applications (VBA). Learn what needs to be in place before using VBA such as the Developer tab in Microsoft Excel. We introduce macros as well.
  • Functions in VBA. This second clip in this VBA video series shows how to create a function in Visual Basic for Applications (VBA) in Microsoft Excel. Follow along through several practical examples.
  • For-loops in VBA. This third clip in this VBA video series shows how to create a loop in Visual Basic for Applications (VBA) in Microsoft Excel.
  • Nested loops in VBA. This fourth clip in this VBA video series shows how to leverage loops within loops (known as nested loops), in Visual Basic for Applications (VBA) in Microsoft Excel.
  • Summary Statistics in VBA. This fifth clip in this VBA video series shows how to leverage summary statistics in Visual Basic for Applications (VBA) in Microsoft Excel. Learn how to write to multiple Microsoft Excel sheets using functions such as Sum, Variance, and Average.
  • Macros in VBA. This sixth clip in this VBA video series shows how to create macros in Visual Basic for Applications (VBA), which work across multiple Microsoft Excel sheets.
  • Exporting Modules, Ranges, and Functions in VBA. This seventh clip in this VBA video series shows how to export modules, ranges, and functions to be used across Microsoft Excel files.
  • If Conditions in VBA. This eighth clip in this VBA video series explains how to create a conditional statement in Visual Basic for Applications (VBA) for Microsoft Excel.
  • User Forms in VBA. This ninth clip in this VBA video series shows you how to create a user form in Visual Basic for Applications (VBA) for Microsoft Excel.