Did you know that Excel contains a built-in programming language that can automate nearly anything for your spreadsheet?
For years I looked upon VBA as an unapproachable power. How would I ever learn to write code?
Eventually, I took the plunge. How about you next?
The primary focus of this blog is not VBA. Sometimes it comes up in passing. But you will not find a soup-to-nuts treatment.
For this I take you to Jon Acampora. Jon is an Excel MVP and friend of the blog. He has demystified VBA for me and can for you, too.
First things first…
If you’ve never used VBA before, you’ll need some housekeeping in your workbook. Sometimes I provide macros to assist in data management.
Watch this video to help you load macros from my blog.
VBA is such a powerful Excel tool. I regret having held off on learning it for so long. Really dig into VBA: Take Jon’s VBA Pro Course. Jon will take you from novice to expert in a series of easy-to-follow training. Watch on your time. Download the exercise follows. Leave questions in the discussion board. It’s the best VBA course on the market.
Use this link and a portion of the revenue will come back to support this blog.
Go for it!
If you have an inclination for VBA, go for it! Don’t be intimidated. If you enjoy this blog, you are a great candidate for learning VBA.