VBA for EXCEL

VBA is very important part of EXCEL which contributes to the programmable ability of EXCEL.

“VBA or VISUAL BASIC FOR APPLICATIONS [ Specifically for Excel in this case ] is the name given to the programming language which is attached with the EXCEL which gives us the power to program EXCEL and take its advantages to another level.

In this tutorial, we'll introduce you to the VBA for EXCEL, take you through the different learning aspects so that you can learn how to use VBA from the scratch and create advanced applications using this unique feature.

NOTE: You don't need any prior knowledge  of VBA.

IN THIS PAGE, YOU'LL FIND THE DIFFERENT ARTICLES WHICH WILL HELP YOU LEARN THE USE OF VBA FROM THE SCRATCH.

CHOOSE THE TOPIC OF YOUR CHOICE

INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS[VBA FOR EXCEL]

INTRODUCTION VBA stands for VISUAL BASIC for APPLICATIONS. As many of you must be aware that VISUAL BASIC is a ...
Read More

HOW TO OPEN VBA IN EXCEL?

INTRODUCTION VBA sits at the back end of Excel. But its always there. VBA sits in the background and in ...
Read More

VBA TERMINOLOGY AND BASIC PROCEDURES

INTRODUCTION In the previous post , we learnt about how to reach VBE through Excel, how to open and close ...
Read More

VBA HELLO WORLD PROGRAM

INTRODUCTION In the previous article we learnt about how to open VBA,what are the different windows in VBA how to ...
Read More

CUSTOM FUNCTION IN EXCEL [THROUGH VBA]

INTRODUCTION We have created our first program HELLO WORLD using the sub procedures or a simple set of statements. The ...
Read More

USE SUB PROCEDURES USING VBA

INTRODUCTION We have created our first program HELLO WORLD using the sub procedures and created a function also. In this ...
Read More

LOOPS IN VBA

INTRODUCTION If you have programmed ever, you must know the importance of the loops. If you are new to programming, ...
Read More

ARRAYS IN VBA

INTRODUCTION The array is a group of same type of elements. Almost all the programming languages support Arrays. Arrays are ...
Read More

VARIABLES AND DATA TYPES IN VBA

INTRODUCTION The programming languages mainly solve our problems with the help of manipulating data. Applying different operations on the data ...
Read More

USE IF THEN ELSE IN VBA

INTRODUCTION In our last lesson, we learnt about different loops. How to program and use the loops. Let us now ...
Read More

GO TO AND SELECT CASE IN VBA

INTRODUCTION-GOTO We discussed the IF THEN ELSE construct which helps us to take a decision. Similarly there are few more ...
Read More

STRINGS IN VBA

INTRODUCTION STRINGS is the specific term given to the normal Text in the programming languages. Strings are very important component ...
Read More

RANGES IN VBA

INTRODUCTION RANGE OBJECT is again one of the mostly used objects in VBA. If you are extremely new to VBA ...
Read More

RANGES IN VBA-II

INTRODUCTION RANGE OBJECT is again one of the mostly used objects in VBA. If you are extremely new to VBA ...
Read More

WORKBOOKS AND SHEETS IN VBA

INTRODUCTION In this article we’ll see some additional functions available for WORKBOOKS AND SHEETS in VBA. Let us understand the ...
Read More

PIVOT TABLES USING VBA

INTRODUCTION PIVOT TABLES are one of the most powerful features in Excel. Pivot Tables are a very old feature of ...
Read More

CREATE CHARTS USING VBA IN EXCEL

INTRODUCTION Charts are a graphic representation of any tabular data which helps us to look over the trend, values , ...
Read More

HOW TO INSERT STRINGS IN EXCEL USING VBA

INTRODUCTION STRINGS is the specific term given to the normal Text in the programming languages. Strings are very important component ...
Read More

HOW TO CONCATENATE TEXT IN VBA

INTRODUCTION STRINGS is the specific term given to the normal Text in the programming languages. Strings are very important component ...
Read More

HOW TO REMOVE CHARACTERS FROM STRING IN VBA?

INTRODUCTION STRINGS is the specific term given to the normal Text in the programming languages. Strings are very important component ...
Read More

SIMPLE COUNTER IN EXCEL USING VBA

SIMPLE COUNTER IN EXCEL USING VBA INTRODUCTION It’s always a great feeling to watch your things work. Similar is the ...
Read More