Скачать или смотреть Excel VBA IF Statement Tutorial – How to Use Conditions in Macros

In this lesson of Excel VBA for Professionals, we introduce the foundational IF statement — a powerful control structure that allows you to make decisions in your VBA macros.

🔍 You'll learn:

The syntax and structure of an IF...THEN...END IF block

How to evaluate a condition and execute code when it's true

How to work with values from cells (not just hardcoded variables)

The difference between one-way IF and more advanced branching (coming next!)

This video builds on the relational and logical operators covered in previous lessons, showing you how to use those skills in real macro decision logic.

00:00 – Intro: Why IF statements matter in VBA
00:20 – Review: Why we covered relational and logical operators first
00:50 – Example setup: Test grade as an Integer variable
01:30 – Writing a simple IF statement: Check if grade greater than 70
02:20 – IF statement syntax in VBA explained
02:50 – Running example: Test grade is 80 (TRUE condition)
03:20 – What happens when the condition is FALSE
04:00 – Demonstration: Changing value to 50, skipping IF block
04:40 – Multiple lines inside IF block (nested logic allowed)
05:10 – Getting values from Excel cells instead of hardcoded numbers
06:00 – Reading from Row 1, Column 1 using `Cells(1,1)`
07:00 – Changing to Row 2 and Row 3: Different outcomes
08:30 – Reminder: (greater than) is not inclusive
09:00 – Summary: IF statement logic with dynamic cell input
09:30 – What's next: ELSE, ELSEIF, and full branching logic
10:00 – Outro: Like, subscribe