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]
Table of Contents INTRODUCTION HISTORY OF VBA NEED OF VBA IN EXCEL VBA – WORKING WITH APPLICATIONS VBA WORKING WITH ...
Read More
Read More
HOW TO OPEN VBA IN EXCEL?
Table of Contents INTRODUCTION MACRO-BRIEF DETAILS RECORDING A MACRO RUNNING A MACRO HOW TO DISPLAY DEVELOPER TAB IN EXCEL? STEPS ...
Read More
Read More
VBA TERMINOLOGY AND BASIC PROCEDURES
Table of Contents INTRODUCTION VBA TERMINOLOGY WHAT ARE PROCEDURES IN VBA STANDARD FORMATS OF PROCEDURES. INTRODUCTION In the previous post ...
Read More
Read More
VBA HELLO WORLD PROGRAM
Table of Contents INTRODUCTION FIRST STEP WRITING THE PROGRAM HELLO WORLD-1-CODE CODE RUNNING PROGRAM THROUGH VBE RUNNING PROGRAM THROUGH MACRO ...
Read More
Read More
CUSTOM FUNCTION IN EXCEL [THROUGH VBA]
Table of Contents INTRODUCTION FIRST STEP WRITING THE PROGRAM PRE PLANNING THE FUNCTION STRUCTURE WRITING THE CODE FOR CUSTOM FUNCTION ...
Read More
Read More
USE SUB PROCEDURES USING VBA
Table of Contents INTRODUCTION STRUCTURE OF A SUB PROCEDURE RUNNING A SUB PROCEDURE ERROR HANDLING IN SUB PROCEDURES EXAMPLE 1-VBA ...
Read More
Read More
LOOPS IN VBA
Table of Contents INTRODUCTION TYPES OF LOOPS IN VBA FOR-NEXT LOOP DO-WHILE LOOP DO-UNTIL LOOP INTRODUCTION If you have programmed ...
Read More
Read More
HOW TO DEAL WITH ARRAYS IN VBA
Table of Contents INTRODUCTION DECLARING ARRAYS IN VBA MULTIDIMENSIONAL ARRAYS IN VBA DYNAMIC ARRAYS IN VBA EXAMPLE 1:USING ARRAYS EXAMPLE ...
Read More
Read More
VARIABLES AND DATA TYPES IN VBA
Table of Contents INTRODUCTION DATA TYPES HOW TO DECLARE VARIABLES IN VBA FOR EXCEL? SCOPE OF A VARIABLE DECLARING CONSTANTS ...
Read More
Read More
USE IF THEN ELSE IN VBA
Table of Contents INTRODUCTION SYNTAX OF IF THEN CONSTRUCT EXAMPLE 1-IF THEN ELSE IN VBA EXAMPLE 2 OF IF THEN ...
Read More
Read More
GO TO AND SELECT CASE IN VBA
Table of Contents INTRODUCTION-GOTO SYNTAX OF GOTO STATEMENT EXAMPLE -GOTO STATEMENT SELECT CASE IN VBA EXAMPLE -SELECT CASE STATEMENT INTRODUCTION-GOTO ...
Read More
Read More
STRINGS IN VBA
Table of Contents INTRODUCTION WHAT IS A STRING IN VBA ? EXAMPLE 1-ENTERING THE STRING/TEXT INTO CELL IN VBA EXAMPLE ...
Read More
Read More
RANGES IN VBA
Table of Contents INTRODUCTION WHAT IS A RANGE IN VBA? SELECT CELLS IN EXCEL USING VBA COPY A RANGE AND ...
Read More
Read More
RANGES IN VBA-II
Table of Contents INTRODUCTION COUNT THE NUMBER OF SELECTED CELL IN VBA COUNT THE NUMBER OF ROWS IN SELECTED CELL ...
Read More
Read More
WORKBOOKS AND SHEETS IN VBA
Table of Contents INTRODUCTION ACTIVATING A WORKBOOK IN VBA SAVING THE WORKBOOK SAVING THE NEW WORKBOOK USING VBA IN EXCEL ...
Read More
Read More
PIVOT TABLES USING VBA
Table of Contents INTRODUCTION CREATING FIRST PIVOT TABLE USING VBA STANDARD STRUCTURE OF CREATING A PIVOT TABLE USING VBA CREATING ...
Read More
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
Read More
HOW TO INSERT STRINGS IN EXCEL USING VBA
Table of Contents INTRODUCTION WHAT IS A STRING IN VBA INSERTING THE STRING / TEXT INTO CELL INTRODUCTION STRINGS is ...
Read More
Read More
HOW TO CONCATENATE TEXT IN VBA
Table of Contents INTRODUCTION WHAT IS A STRING IN VBA CONCATENATE THE TEXT GIVEN IN THE CELLS D3 , D4 ...
Read More
Read More
HOW TO REMOVE CHARACTERS FROM STRING IN VBA?
Table of Contents INTRODUCTION WHAT IS A STRING IN VBA REMOVING ANY SPECIFIC CHARACTER/S FROM A STRING IN VBA INTRODUCTION ...
Read More
Read More
SIMPLE COUNTER IN EXCEL USING VBA
Table of Contents INTRODUCTION OBJECTIVE PRE PLANNING VBA PROGRAMMING PREPARATION FOR THE PROJECT CODING VBA INTRODUCTION It’s always a great ...
Read More
Read More