Just like in excel, you can use for addition - for subtraction for multiplication for division.

You may not necessary end up working as a programmer or writing programs at all but it will teach you how to think.

In this tutorial, we are going to cover the following topics.

What is VBA Why VBA Personal business applications of VBA in excel Visual Basic For Applications VBA basics Step by step example of creating a simple EMI calculator in Excel What is VBA VBA stands for Visual Basic for Applications.

Before we go into further details, lets look at what computer programming is in a laymans language.

You tell her what to do using lets say English and she does the work for you.

As you work with a computer, you will want to perform certain tasks.

Just like you told the maid to do the house chores, you can also tell the computer to do the tasks for you.

The process of telling the computer what you want it to do for you is what is known as computer programming.

The English like statements fall in the category of high level languages.

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.0 BASIC stands for B eginners A ll-Purpose S ymbolic I nstruction C ode.

Why VBA It uses English like statements to write instructions Creating the user interface is like using a paint program.

You just have to drag, drop and align the graphical user interface controls.

From day one that you start learning, you can immediately start writing simple programs.

Enhances the functionality of excel by allowing you to make excel behave the way you want it to Personal business applications of VBA in excel 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.

Visual Basic for Applications VBA basics Before we can write any code, we need to know the basics first.

They can be assigned any numbers i.e.

As you work with VBA, you will be required to declare variables too just like in algebra classes Rules for creating variables Dont use reserved words if you work as a student, you cannot use the title lecturer or principal.

These titles are reserved for the lecturers and the school authority.

Reserved words are those words that have special meaning in Vba and as such, you cannot use them as variable names.

Variable names cannot contain spaces you cannot define a variable named first number.

Use descriptive names its very tempting to name a variable after yourself but avoid this.

Visual Basic Excel For Mac