Course Overview

Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA! Over the course, we'll cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics.

Course Modules

Object Oriental Programming
Collection Object in Real Life
Objects As Properties
The Excel Object Model
Access Object by Name
Access Default Properties
The Name Property on Workbook and Worksheet Objects
Objects and Methods
- - Methods with arguments
- - Method without arguments
- - Method with multi arguments
- - The Object Browser
- - How to call a procedure
- - The TypeName method
- - Variable Declarations
- - Multiple Variable Declarations
- - The Option Explicit Syntax
- - The Byte, Integer and Long Data Type
- - Numeric Data Types
- - Mathematical Operators
- - Boolean operator
- - Date Data Types
- - Quiz for variable and class declarations

Procedure
- - Variable Scope
- - Call a procedure from another procedure
- - Procedure access level
  - Private
  - Public
- - When to use Exit Sub
- - Constraints
- - Predefined Constraints
- - Advance Object Oriented Programming
  - Application Object
  - The Application.Display Alert
  - Worksheet Object
- - Range.Select Method
- - Value and Text Property
- - Formula and R1C1 Properties
- - Range Offset Property
- - Range. Resize Property
- - Cells
- - Get Last row of Data in a Worksheet

Set Theory Primer
Repeat a task
For Next Loop
Step through all items of a collection object
For Each Loop
Do Loop
If then else statement
Case statement
Managing Workbook elements and data
Write a value in a cell
Cut Copy Paste cell data
Find values in cells
Refer to cell using the offset functions
Concatenating text strings
Return part of a string
Managing worksheets with VBA
Managing workbooks with VBA

Run a procedure when you open, close, or save a workbook
Run a procedure when a cell range changes
Trigger a procedure using a specific key sequence
Worksheet_Activate event
Worksheet_Open event
Worksheet_Change event
Application.EnableEvents method
Worksheet_SelectionChange event
Other Worksheet events

Label and TextBox Control
Naming convention
Design Aesthetics
Event Procedure to Control
Activate a UserForm from a procedure
The Initialize Event
ListBox Control
- - Wire up a form
- - React to user selection
- - Selecting Multiple Items
Combobox
Checkbox

FAQ

Any graduate, fresher, experienced and looking to start or change their career into data analytics can attend. No prior experience is mandatory.

Absolutely. We start the training from scratch. After completing the course you will not feel that you have never programmed.

Yes

Our trainers are from the industry. Every class is followed by real time assignments which will make you feel confident when you get into a job.

Fully online. You can attend from anywhere. You just need a laptop and a good internet connection

Yes 100%. It is live and fully interactive. We don't believe in running through power point presentations.

Please contact on the given number.

Back to All Courses

VBA Programming

VBA Programming

VBA Programming

Course Overview

Course Modules

FAQ

REQUEST MORE INFORMATION

Back to All Courses

VBA Programming

VBA Programming

VBA Programming

Course Overview

Course Modules

Module 1: Fundamentals of the Excel Object Model

Module 2 - Procedures and Advanced Object-Oriented Concepts

Module 3 - Add Logic to your program

Module 4 - Event Handling

Module 5 - User Forms

Module 6 - Capstone project

FAQ

Who can attend this course?

I don't have any programming background, still can I pursue?

Do you provide job assistance?

Do you provide real time use cases?

Are the classes online or classroom?

Are the classes be live?

How do I apply ?

REQUEST MORE INFORMATION