In this chapter, you covered a considerable amount of material on some of the tools required to help you build a strong programming foundation. You started by taking an in-depth look at procedures in VBA; specifically, event, sub, and function procedures. You learned how to use and build these procedures while considering the procedure's scope, available parameters, and return values (function procedures). You even learned how to build new function procedures to use within formulas created in the Excel application. Finally, you saw two new code structures, If/Then/Else and Select/Case and you learned how to use Boolean logic within conditional expressions so a program could branch off in different directions in terms of code execution. In essence, you learned how to write a program that can make simple decisions.
The Poker Dice game board after two rolls.
Was this article helpful?