Our introduction to VBA in yesterday’s lesson encompassed a lot of conceptual and foundational information. Today, you get to roll up your sleeves and actually start doing something with VBA.
What are Standard modules
What are Class modules
What is the basic structure of a module
What are procedures
How to pass arguments to procedures
What are variables
Many of the concepts we’re going to cover today and tomorrow can be very confusing if you’ve never done any programming before. We’re also facing a “chicken-before-the-egg” problem in many cases, because it can be difficult to grasp one concept before learning another one we haven’t yet covered. If you don’t fully understand something we’re ...