Let’s get back to the question in the header, “Why learn VBA today?” You Can Pretty Much Do ANYTHING! Teaching yourself how to automate specific tasks can be as easy as using the recorder and copying the code it spits out. While it might not be the most efficient way to write the code, it writes it in a way that in most cases automates your process without any further modifications. This feature allows you to click a record button and it will write code for every single thing you physically carry out on your screen. There’s no weird syntax like curly brackets or a complex lexicon of phrases to memorize, you simply write what you want to do and it is done.īut the real beauty of VBA and it’s ease of learning is the availability of the Macro Recorder. How? Because VBA is something that makes sense to anyone familiar with Excel (or Word or PowerPoint). Needless to say I am not the poster child to be somewhat authoritatively writing about a computer coding language.īut I am. Why is this important to clarify? Well, I want to stress I know nothing about computers, computer coding, or how it is physically possible to send information like this article through the air and into millions (ok, hundreds…) of digital devices to be read. I, Chris Newman, founder of TheSpreadsheetGuru, am first and foremost a finance guy. Now before I get too far, let’s back up and talk about me for a minute. To simply put it, it’s something that virtually anyone can teach themselves with very little effort.

But there is hope and through this article, I will present my thoughts and predictions about the so-called “inevitable death” of the VBA coding language. I constantly see questions on forums asking “is it worth learning VBA at this point in time?” or “when will VBA stop working?” or better yet, “what is replacing VBA?”.ĭon’t get me wrong, these are all valid questions especially with the way Microsoft has treated VBA over the past 10 years. With its endless popularity in such programs as Excel, it might come as a surprise that there is this lingering fear VBA is going to be removed from Microsoft Office in the near future. It’s a language that has been around for decades and is one of the easiest coding languages to learn if you don’t have a computer science background.

VBA is a coding language used by millions of people across the world to automate tasks in Microsoft Office products.

Vba for office 365