Learn VBA for Excel

Variables & Statements (Part 2 of 3)

Learn VBA for Excel

Automate Excel with Statements

About this video

Once you start writing your own macros you will want to expand on those skills and this video adds automation and decision making to your VBA Toolbox. You will also learn what variables are and how to incorporate them into your code.

This video covers the three most commonly used statements in VBA. You will learn how, when and why you would want to use them and how to automate decision making. Additionally, you will learn about variables and the various types. Then we will finish the lesson automating another tedious task.

What you'll learn

  • Variable Types
  • 3 Most Commonly Used Statements
    • If – Then
    • Do Loop
    • For Each
  • Infinite Loops & How to Avoid Them
  • Objects
  • Planning your code
  • Automation Example 
  • & More!

Next Lesson: Forms & Functions

Previous Lesson: Excel Environment

Your content goes here