This will open a wizard box for us somewhat like this,.We get three options, select Record Macro.In the View tab, we have a Macros section click on it.Let us learn all these in examples which will help us to understand it better. Recording macro is recording steps we perform and let excel do it over and over when we give the command to do it. In this Excel VBA tutorial for beginners, before we move to learn how to write codes in VBA, let us start with the most basic function of VBA, which is to record a macro. The most advisable thing to do is learn by recording the macro and look at the code to learn the syntax, which will help us in writing the codes of our own. The second is by writing a block of codes.There are two methods for using VBA in Excel.
Now we have the developer’s tab enabled in excel as follows. When we drag down in the customize ribbon options, we will find an option for Developer we need to check that box which will enable us to use VBA in excel. In excel options, click on Customize Ribbon. It will open another wizard box for us as Excel Options. 
In the files tab, we will find a section for options in the last from the bottom click on Options. Go to the File tab on the home page of excel. If you don’t see the developer tab in your excel, follow the below steps to enable the developer tab in excel. To access VBA, we need to follow some steps first, as listed below.Īs VBA is different from the normal worksheet we work upon, it contains macros, so saving it is different from other normal workbooks when we save a workbook that contains macros, we need to save it as a macro-enabled workbook to ensure that our macros are saved in the workbook. 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.
0 kommentar(er)
