What is the difference between 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.

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.

Macro and VBA

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Drop us a message even when it’s late because the best ideas can come at night.

About Aeternus Singapore

aeternus consulting singapore logo
Aeternus Consulting is the premier consultancy firm for analyst-grade Microsoft Office training courses in Singapore. ACRA: T14LL0891K

Microsoft Office training solutions

corporate training course chair
We work with businesses and individuals who need effective Microsoft Office training solutions.

Analyst-Grade Training Courses

analytics with microsoft excel chart
Premium Training for Business Analysts, Data Analysts & Information Specialists in Singapore.

Our Services Include

Our Microsoft Office-centric services include:
* Full range of Microsoft Excel Training Courses in Singapore.
* Microsoft Office PowerPoint Training Courses.
* Consultancy in Excel, Access, VBA Application Development & PowerPoint Presentation Design Projects.
* Personal coaching & corporate bespoke Microsoft Office training sessions for employees.

Training Course List

Excel Basic, Intermediate, Advanced Levels
Excel PivotTables Inside Out
Data Management & Data Analysis in Excel
VBA Programming with Excel
Advanced VBA Programming with Excel
Essential Microsoft Excel for HR Professionals
Up to Speed with Microsoft PowerPoint
PowerPoint Design & Animation Ideas for Business
Microsoft SharePoint Training Workshop

Instagram (@aeternusconsulting)