By default, VBA is not accessible in excel. Here we record a set of instructions by writing some block of codes, and when we run these blocks of codes, they do the specified tasks for us. VBA is basically a programming language just like C and Java and everything else. Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more. But it has certain limitations to it, so we write codes in VB Editor where there is an ultimate number of opportunities to automate our tasks. In excel, we have a special feature in which we record our steps, and excel does the same steps for us over and over when giving excel command to run that code. One is through writing codes in VBA itself, while another is done by recording a macro.

There are two ways to give these instructions for macros. In VBA, we create macros, and as defined above, macros are a set of instructions that are given to do a specific task. It is the best VBA Tutorial for beginners. In this article, we will learn about the basics of VBA. What is a macro again? Macro is a set of instructions that are given to do a specified task. But by using VBA, we can make our jobs easier as we can make macros that will do our repetitive tasks for us. In Excel, we do our tasks manually or by formulas but the tasks which are repetitive needs to be done again and again. VBA or Visual Basic Applications is a part of Microsoft Excel.

How to enable vba in excel 2016