What are the payment options?

You can choose from a multitude of payment options, including Cash, Cheque, Credit Card, Debit Card or Net Banking.

Who are the Instructors?

We, at Croma Campus, have a dedicated team of instructors who are real-time professional from the industry and have nearly a decade of relevant experience.

What if I have queries after I complete this course VBA?

You can access the Support and your query will be solved accordingly.

Do you provide placement assistance?

We will train you accordingly, allowing you to get attractive job offers at the time of an interview.

How will I execute the Practical?

We will provide you with a step-by-step procedure guide for your practical work.

Home /Data Analytics & BI/ Microsoft Excel VBA Training Program

Learn to automate tasks with an MS Excel VBA expert. Join now to learn from a VBA expert.

4.8 out of 5 based on 24900 votes

4.2/5

4.8/5

4.6/5

4.3/5

4.5/5

Course Duration

25 Hrs.

Live Project

2 Project

Certification Pass

Guaranteed

Training Format

Live Online /Self-Paced/Classroom

Watch Live Classes

GUIDE ME

Speciality

200+

Professionals Trained

Batches every month

20+

Countries & Counting

100+

Corporate Served

CURRICULUM REAL STORIES PROJECTS COURSE FEE SELF-ASSESSMENT ACTIVITIES PLACEMENTS practice tests ENROLL NOW

CURRICULUM & PROJECTS

Microsoft Excel VBA Training Program

It is estimated that the job opportunities for VBA programmers are set to grow exponentially given the current demand and estimated growth in the number of companies seeking out such individuals. With the VBA (Visual Basic for Applications) training by Croma Campus, learn how to create macros to automate functions and generate graphs and reports.

In this program you will learn:

VBA Basics.

Control Structures: Logical Expressions.

Control Structures: Loops.

Sub-Procedure and Functions.

Debugging.

Handling Text files, Pictures and charts.

VBA forms.

Database Connectivity:

Get full course syllabus in your inbox

What is VBA:

Overview

The History of VBA

Why VBA

VBA Summary

Available Data Types and Usage

Micro Structure & Basic Macro

Active sheet, Active cell, offset, sheet add, rename, etc.

Options Base and Explicit

Arrays

Static & Dynamic

Array functions

Macro with Excel

Basic Macro with daily use

Filter, cut, copy, paste, remove duplication, etc.

Macro with File

File system basics

Understanding file permissions

Setting file permissions

Accessing files

Writing to files

Deleting files

Reading files

Examining file details

Working with directories

Viewing directory content

Form and Activity X Control

Get full course syllabus in your inbox

Control Structures: Logical Expressions:

If statements

Else and elseif statements

Logical operators

And. OR, Not. Go to Statements

Switch statements

Get full course syllabus in your inbox

Control Structures: Loops:

While loops

For loops

For each loops

do while

do until

Continue

Break

Understanding array pointers

Get full course syllabus in your inbox

Sub-Procedure and Functions:

Subroutine

Passing value to sub- procedure

Message box

VBA Inbuilt functions

Passing values in functions

Workbook and worksheet functions

Keywords

Difference between sub-routines and functions

Creating own functions in VBA for Excel

Get full course syllabus in your inbox

Debugging:

Common problems

Warnings and errors

Debugging and troubleshooting

Get full course syllabus in your inbox

Handling Text files, Pictures and charts:

Open, Edit and close text files.

User form controls & ActiveX controls

Excel ribbon controls using VBA

Get image in user form

Image box from VBA

Handle charts in multiple sheets.

Event Handling

Get full course syllabus in your inbox

VBA forms:

Understanding VBA forms and options

Check box

Option button

List box

Form properties

Labels

Boolean

VBA basic data entry forms

VBA advanced forms

Get full course syllabus in your inbox

Database Connectivity:

Connection string for SQL and Access

Bring data from table to excel

Advanced macros

Mail automation using macros

Mail automation with attachments

Macros to create pivot tables and charts

Get full course syllabus in your inbox

Placement Guide:

What is an Interview

Tips to clear an Interview

Common Interview questions and answers

VBA Interview Questions and Answers

Resume Building Guide

Career roadmap and certifications

Attempt for related Global Certification Exam, if any

Start applying for Jobs

Get full course syllabus in your inbox

What is VBA

Overview

The History of VBA

Why VBA

VBA Summary

Available Data Types and Usage

Micro Structure & Basic Macro

Active sheet, Active cell, offset, sheet add, rename, etc.

Options Base and Explicit

Arrays

Static & Dynamic

Array functions

Macro with Excel

Basic Macro with daily use

Filter, cut, copy, paste, remove duplication, etc.

Macro with File

File system basics

Understanding file permissions

Setting file permissions

Accessing files

Writing to files

Deleting files

Reading files

Examining file details

Working with directories

Viewing directory content

Form and Activity X Control

Get full course syllabus in your inbox

If statements

Else and elseif statements

Logical operators

And. OR, Not. Go to Statements

Switch statements

Get full course syllabus in your inbox

While loops

For loops

For each loops

do while

do until

Continue

Break

Understanding array pointers

Get full course syllabus in your inbox

Subroutine

Passing value to sub- procedure

Message box

VBA Inbuilt functions

Passing values in functions

Workbook and worksheet functions

Keywords

Difference between sub-routines and functions

Creating own functions in VBA for Excel

Get full course syllabus in your inbox

Common problems

Warnings and errors

Debugging and troubleshooting

Get full course syllabus in your inbox

Open, Edit and close text files.

User form controls & ActiveX controls

Excel ribbon controls using VBA

Get image in user form

Image box from VBA

Handle charts in multiple sheets.

Event Handling

Get full course syllabus in your inbox

Understanding VBA forms and options

Check box

Option button

List box

Form properties

Labels

Boolean

VBA basic data entry forms

VBA advanced forms

Get full course syllabus in your inbox

Connection string for SQL and Access

Bring data from table to excel

Advanced macros

Mail automation using macros

Mail automation with attachments

Macros to create pivot tables and charts

Get full course syllabus in your inbox

What is an Interview

Tips to clear an Interview

Common Interview questions and answers

VBA Interview Questions and Answers

Resume Building Guide

Career roadmap and certifications

Attempt for related Global Certification Exam, if any

Start applying for Jobs

Get full course syllabus in your inbox

+ More Lessons

Course Design By

Nasscom & Wipro

Course Offered By

Croma Campus

Real

Stories

success

inspiration

Abhishek

career upgrad

Upasana Singh

career upgrad

Shashank

career upgrad

Abhishek Rawat

career upgrad

Course Duration

25 Hrs.

Know More...

Weekday1 Hr/Day

Weekend2 Hr/Day

Training ModeClassroom/Online

Flexible Batches For You

05-Jul-2025*
Weekend
SAT - SUN
Mor | Aft | Eve - Slot

30-Jun-2025*
Weekday
MON - FRI
Mor | Aft | Eve - Slot

02-Jul-2025*
Weekday
MON - FRI
Mor | Aft | Eve - Slot

05-Jul-2025*
Weekend

SAT - SUN

Mor | Aft | Eve - Slot

30-Jun-2025*
Weekday

MON - FRI

Mor | Aft | Eve - Slot

02-Jul-2025*
Weekday

MON - FRI

Mor | Aft | Eve - Slot

Course Price :

For Indian

13,500 12,150 10 % OFF, Save 1350

Expires in: 00D:00H:00M:00S

Program fees are indicative only* Know more

SELF ASSESSMENT

Learn, Grow & Test your skill with Online Assessment Exam to
achieve your Certification Goals

Get exclusive
access to career resources
upon completion

Mock Session

You will get certificate after
completion of program

LMS Learning

You will get certificate after
completion of program

Career Support

You will get certificate after
completion of program

Showcase your Course Completion Certificate to Recruiters

Training Certificate is Govern By 12 Global Associations.
Training Certificate is Powered by “Wipro DICE ID”
Training Certificate is Powered by "Verifiable Skill Credentials"

in Collaboration with

Not Just Studying

Name: Microsoft Excel VBA Training Program
Item: Microsoft Excel VBA Training Program
Rating: 4.80

We’re Doing Much More!

Empowering Learning Through Real Experiences and Innovation

Career Transition

Career Gap

Placement Activities

Placement Drives

Latest Hiring

Whats App Reviews

Mock Interviews

Prepare & Practice for real-life job interviews by joining the Mock Interviews drive at Croma Campus and learn to perform with confidence with our expert team.Not sure of Interview environments? Don’t worry, our team will familiarize you and help you in giving your best shot even under heavy pressures.Our Mock Interviews are conducted by trailblazing industry-experts having years of experience and they will surely help you to improve your chances of getting hired in real.

How Croma Campus Mock Interview Works?