Lesson 1. About Excel VBA

About Excel VBA 

VBA stands for Visual Basic for Applications, and event driven programming language from Microsoft. It is now predominantly used with Microsoft Office Applications, Such as MS Excel, MS Word & MS Access.

What is VBA

VBA stands for Visual Basic for Applications. And event driven Programming Language from Microsoft with Microsoft Office Applications. Such as MS Word, MS Excel, MS Access.

VBA allows you to automate various activities in excel, Such as generating reports, preparing charts & graphs doing calculations etc. This automation activity is also known as Macro.

VBA helps to build customized applications and solutions to enhance the capabilities of these applications.

The advantage of this facility is that you don't have any need to install visual basics on your desktop, and installing office will ultimately help you to achieve the purpose. Also you can build very powerful tools in MS Excel using linear programming.

VBA can use in all office versions. VBA is a high level language. VBA is a Subset of Visual Basic 6.0.

BASIC stands for Beginners All Purpose Symbolic Instruction Code.

Why VBA?

Some points clear to you why use VBA such as:

1. VBA uses simple English statements to write the instructions.

2. Creating the user interface is a drag, drop and align the graphical user interface controls in VBA.

3. VBA is a very simple to learn and required basics programming skills.

4. VBA enhance the functionality of excel by allowing you to make excel behave according to your need.

Application in VBA

You think why to use VBA in Excel as MS Excel itself provides loads of inbuilt functions.

MS Excel provides only essential inbuilt functions that may not be sufficient to perform complex calculations. Under such circumstances, VBA becomes the most transparent solution.

For Example: Using Excel's built in formulas is tough to calculate the monthly repayment of the loan. But it is easy to program a VBA for this kind of calculations.

VBA Basics

First, You need to know about the basics before starting or write any code. There are some basics given below.

Variable: Variables are the memory locations. and to work with VBA, You will be required to declare variables.

For Example: Suppose (2x+5y) Where x=1, y=2, in this given expression, x and y are the variables or can be assigned any numbers. i.e., 3 and 4 respectively.

Rules for Creating Variables

1. Don't use reserved word: Reserved words are those words which have special meaning in VBA, so you can't use them as variable names.

2. The variable name cannot contain space: You cannot define a variable name with space such as the Last Number. You can use LastNumber or Last_Number.

3. Use Descriptive names: Use descriptive names such as price, quantity, subtotal etc. This will make your VBA Code easy to understand.

Arithmetic Operator    

We use the BODMAS Rule during brackets of division, multiplication, addition and subtraction when working with an expression which uses multiple different arithmetic operators.

1. + for addition

2. - for subtraction

3. * for multiplication 

4. / for division

Logical Operator

The concept of the logical operator is also applied when working with VBA such as.

1. If statements

2. AND

3. OR

3. NOT

4. TRUE

5. FALSE

Happy Learning

Thanks for Visit This Post. Computer Related Any Query Please Contact Us.

Call / WhatsApp: +91 9650597419 (Vinay Sir)