19.1 Introduction
Write VBA code, including variable declarations, constants, strings, dates, operators, and arrays.
Differentiate between VBA functions and worksheet functions.
Utilize the If...Then, Select Case, For, Do While, Do Until, and For Each statements to create efficient and effective VBA code.
Use the Select Case statement to execute code depending on the value of an expression.
Implement the Volatile keyword to signal to VBA to recalculate when any cell's value on the sheet changes.
Create User-Defined Functions that implement a variety of VBA control flow statements.
Troubleshoot User-Defined Functions if the results don't match the expected outcome.
This lesson introduces you to several VBA commands or statements that will be useful when you write your own user-defined functions or VBA macros. Generally, these commands are referred to as control flow statements because they will allow you to decide what code you would like to execute and under what conditions.