Microsoft visual basic for applications vba

Selecting a language below will dynamically change the complete page content to that language. KB Articles: KB Security bulletins: MS Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts. VBA is a high level language that you can use to bend excel to your all powerful will. VBA is actually a sub set of Visual Basic 6. VBA enables you to use English like statements to write instructions for creating various applications.

VBA is easy to learn, and it has easy to use User Interface in which you just have to drag and drop the interface controls. It also allows you to enhance Excel functionality by making it behave the way you want. For personal use, you can use it for simple macros that will automate most of your routine tasks.

Read the article on Macros for more information on how you can achieve this. For business use, you can create complete powerful programs powered by excel and VBA. The advantage of this approach is you can leverage the powerful features of excel in your own custom programs. Before we can write any code, we need to know the basics first. The following basics will help you get started.

Now we will demonstrate how to program in VBA programming language. Here the name is the name you want to assign to your program. While sub stands for a subroutine which we will learn in the later part of the tutorial.

Your complete code window should now look as follows. In this tutorial exercise, we are going to create a simple program that calculates the EMI. The following image shows the formula for calculating EMI. The above formula is complex and can be written in excel.

The good news is excel already took care of the above problem. Selecting a language below will dynamically change the complete page content to that language. KB Articles: KB Warning: This site requires the use of scripts, which your browser does not currently allow.

See how to enable scripts. Select Language:. By installing this update, you can help protect your computer. Details Version:. File Name:.