To explain the question “What is the Difference between a Macro and VBA ?”, let’s start from a simpler question “What is the Difference between a Book and English?”. Well, a book contains text that humans can read to understand ideas, abstract concepts, instructions and English is the language that a book can be written in. Get the idea? And that is the similar answer to the question “What is the Difference between a Macro and VBA?”.
Trying to compare a Macro and VBA is quite fruitless as there are little grounds for comparison because both are very different concepts. A better question is to ask “What is the Relationship between a Macro and the computer language VBA”. And my answer will fit this new question much better: A Macro is a set of instructions that when read and understood by Microsoft Excel, it will perform work for the Excel user. Similar to a book, a Macro is written in a language known as “VBA” (which stands for “Visual Basic for Applications”) that Microsoft Excel is built to understand.
Now you might be wondering where on earth does a Macro comes from. You can create a Macro by using an Excel feature called “Macro Recorder” found in the Developer’s Ribbon.
The macro recorder records a user actions so that Excel can repeat them with less human effort. And without going into difficult details, this “Macro” is written in a computer language called “VBA” that was invented by Microsoft back in 1993.
About Aeternus Consulting
Aeternus Consulting is the premier training center for VBA Courses, VBA Programming Language and Excel Macro Courses in Singapore.
Related Link: Aeternus Consulting VBA Training Courses Singapore