In this lesson we cover how to write IF statements in VBA. The IF statement is the basic unit of logic in Excel programming. It gives your program the ability to 'think' and perform actions based on one or several conditions...

Buy Now From Amazon

Product Review

In this lesson we cover how to write IF statements in VBA. The IF statement is the basic unit of logic in Excel programming. It gives your program the ability to 'think' and perform actions based on one or several conditions. Along with that topic, we review how to use the OFFSET function programmatically and the ActiveCell.

As with all the other lessons, there is a sample workbook you can get from my website to follow along with the exercises.

Similar Products

Mastering Excel Macros: Beginning to Code (Book 3)Mastering Excel Macros: Debugging (Book 2 of Mastering Excel Macros)Mastering Excel Macros: Looping (Book 5)Mastering Excel Macros: Object Variables (Book 6)Mastering Excel Macros: PowerPoint Automation (Book 7)Mastering Excel Macros: FileSystemObject  (Book 8)Mastering Excel: User FormsMastering Excel: Building DashboardsMastering Excel Formulas IF, AND, ORMastering Excel: Pivot Tables