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]

Table of Contents INTRODUCTION HISTORY OF VBA NEED OF VBA IN EXCEL VBA – WORKING WITH APPLICATIONS VBA WORKING WITH ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

STRINGS IN VBA

Table of Contents INTRODUCTION WHAT IS A STRING IN VBA ? EXAMPLE 1-ENTERING THE STRING/TEXT INTO CELL IN VBA EXAMPLE ...

RANGES IN VBA

Table of Contents INTRODUCTION WHAT IS A RANGE IN VBA? SELECT CELLS IN EXCEL USING VBA COPY A RANGE AND ...

RANGES IN VBA-II

Table of Contents INTRODUCTION COUNT THE NUMBER OF SELECTED CELL IN VBA COUNT THE NUMBER OF ROWS IN SELECTED CELL ...

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 ...

PIVOT TABLES USING VBA

Table of Contents INTRODUCTION CREATING FIRST PIVOT TABLE USING VBA STANDARD STRUCTURE OF CREATING A PIVOT TABLE USING VBA CREATING ...

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 , ...

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 ...

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 ...

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 ...

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 ...