Lesson 9: Arrays, Class Modules, Trapping Events, Objects and Collection - VBA Course

Arrays are beneficial when you need to store several values into one variable. Classes are reusable and can plug into other programs, so you can save time in future coding projects with your classes.