Intro to VBA: Reading, Writing and Running Code (Part 3 of 3)

A Tip for Reading a Line of Code – Go Backwards

When you are learning to write code, it's best if you know how to read it.  Sometimes you'll see a long line of code with a lot of dots and think, “what does that mean???”

I find that reading code backwards helps.  Start with last word and work your way left, replacing the dots/periods with the words, “of” or “of the”.

Reading VBA Code Backwards - Intro to VBA

Continue reading


Intro to VBA: Macros Explained in the Kitchen (Part 1 of 3)

What is VBA?

Visual Basic for Applications (VBA) is the programming language we use when writing macros in Excel (and other Office programs). It allows us to program Excel so we can save time with boring repetitive tasks, and focus on the fun stuff. We can use VBA for everything from automating a simple task to developing robust applications and add-ins.

What Does VBA Code Mean - Confused

Continue reading


Do You Use VBA?

As I mentioned in the newsletter, my long awaited VBA Pro Course is coming soon. This is an online video course that will help you learn how to automate Excel. It will cover everything from writing simple macros to developing apps and add-ins.

Continue reading