
Introduction the VBA - Visual Basic for Applications - The Complete Course
Overview of Visual Basic for Applications (VBA):
What is Visual Basic for Applications (VBA)
VBA and Microsoft Excel
What is Object Oriented Programming in VBA
What are the Objects in Excel and how to refer to them via VBA
Introduction to Visual Basic for Applications (VBA)
How to access and use VBA in Microsoft Excel
How to record a macro in VBA
How to run a macro in VBA
How to edit a macro in VBA at your needs
Overview of Excel version 2013
How to protect a Worksheet in Excel
How to protect a Worksheet in Excel and make some cells only scrollable and/or selectable
How to protect a VBA Project from being viewed
How to access the VBA Editor or VBE
The property window in VBE
The List of Projects and Modules in VBA
Where to find Forms and Modules in VBE
How to add a Form or Module in VBA
The VBE Menu
The VBA Toolbar
Where to find the commands and objects for Forms in VBE
How to edit the content of a Form in VBE
How to edit the code of a Form in VBE
Write your code in VBE
Overview of the VBE in the version 2013
Overview of the Developer Ribbon in Excel version 2013
How to write your code in Visual Basic for Applications (VBA)
How to assign VBA code to Excel Objects
The Steps to write a simple VBA code
What is an Object in Visual Basic for Applications (VBA)
What are Methods, Events and Properties of an object in Visual Basic for Applications (VBA)
Analyze a recorded macro in Visual Basic for Applications (VBA)
What is a Function in Visual Basic for Applications (VBA)
What is a Sub or Subroutine in Visual Basic for Applications (VBA)
Public and Private Functions and Sub in Visual Basic for Applications (VBA)
The difference between a Function and a Sub in Visual Basic for Applications (VBA)
Variables in Visual Basic for Applications (VBA)
Constants in Visual Basic for Applications (VBA)
Type of variables in Visual Basic for Applications (VBA)
Private and Public variables in Visual Basic for Applications (VBA)
Function declarations in Visual Basic for Applications (VBA)
Explicit or Implicit variables in Visual Basic for Applications (VBA)
Explicit and Implicit declarations in Visual Basic for Applications (VBA)
How to declare a variable in Visual Basic for Applications (VBA)
How to declare a function in a library in Visual Basic for Applications (VBA)
What is a Type in Visual Basic for Applications (VBA)
How to declare Types in Visual Basic for Applications (VBA)
Define the dimension of a variable in Visual Basic for Applications (VBA)
Re-define the dimension of a variable at runtime in Visual Basic for Applications (VBA)
Modify the dimension of variables in Visual Basic for Applications (VBA)
Details on Objects in Microsoft Excel and how to refer to them in Visual Basic for Applications (VBA)
The Workbook Object in Visual Basic for Applications (VBA)
The Worksheet Object in Visual Basic for Applications (VBA)
The Range and Cells Object in Visual Basic for Applications (VBA)
Worksheet properties in Visual Basic for Applications (VBA)
Worksheet events and methods in Visual Basic for Applications (VBA)
Workbook properties in Visual Basic for Applications (VBA)
Workbook events and methods in Visual Basic for Applications (VBA)
The Cells objects and their properties in Visual Basic for Applications (VBA)
The Range objects and their properties in Visual Basic for Applications (VBA)
How to refer to Excel cells in Visual Basic for Applications (VBA)
How to define a range in Excel and refer to in Visual Basic for Applications (VBA)
How to add VBA controls in an Excel worksheet
How to assign events to VBA controls in an Excel Worksheet
Overview of the Range Object in Visual Basic for Applications (VBA)
How to refer to a range by address in Visual Basic for Applications (VBA)
How to refer to a range by rows and columns in Visual Basic for Applications (VBA)
The properties of the Range object in Visual Basic for Applications (VBA)
The special range object: the Selection object in Visual Basic for Applications (VBA)
The properties, methods and events of the Selection object in Visual Basic for Applications (VBA)
How to refer to ranges in other worksheets in Visual Basic for Applications (VBA)
The Offset property of ranges in Visual Basic for Applications (VBA)
How to use the Offset property to get an element in an Excel range in Visual Basic for Applications (VBA)
How to retrieve the address of a range object in Visual Basic for Applications (VBA)
How to set the size of a range object in Visual Basic for Applications (VBA)
How to select a range with Visual Basic for Applications (VBA)
How to refer to a range or element of a range by row and column in Visual Basic for Applications (VBA)
How to join ranges in Visual Basic for Applications (VBA)
How to merge ranges in Visual Basic for Applications (VBA)
How to select ranges in Visual Basic for Applications (VBA)
How to intersect ranges in Visual Basic for Applications (VBA)
How to verify if an object is empty in Visual Basic for Applications (VBA)
The CurrentRegion property in Visual Basic for Applications (VBA)
How to retrieve the current region of an object or range in Visual Basic for Applications (VBA)
The Area Collection properties in Visual Basic for Applications (VBA)
How to evaluate the position of elements in an Excel worksheet using the range properties in Visual Basic for Applications (VBA)
The End property of an Excel range in Visual Basic for Applications (VBA)
The parameters of the End property of an Excel range in Visual Basic for Applications (VBA)
identify ranges and cells in the object hierarchy, the value property, define a range with the "set" instruction
How to create a macro to automatically format a range in Visual Basic for Applications (VBA)
How to add borders and colors to a range in Excel using Visual Basic for Applications (VBA)
Special cells in Excel with Visual Basic for Applications (VBA)
The SpecialCells method of Excel ranges in Visual Basic for Applications (VBA)
How to refer to cells of specified types and values in Visual Basic for Applications (VBA)
How to select the cells containing data in Excel using Visual Basic for Applications (VBA)
How to show messages in Visual Basic for Applications (VBA)
The Msgbox Dialog and object in Visual Basic for Applications (VBA)
How to manage the standard Excel Dialog forms in Visual Basic for Applications (VBA)
How to customize an Excel dialog box in Visual Basic for Applications (VBA)
The parameters and constants to use to customize the dialog boxes in Excel using Visual Basic for Applications (VBA)
How to customize query dialog boxes in Excel using Visual Basic for Applications (VBA)
The SaveAs queries in an Excel Message Dialog box in Visual Basic for Applications (VBA)
How to customize messages and the behavior of the message boxes in Excel using Visual Basic for Applications (VBA)
How to input data in Excel using the InputBox in Visual Basic for Applications (VBA)
How to customize data entry in Visual Basic for Applications (VBA)
The VBA Constants in Visual Basic for Applications (VBA)
How to find the VBA constants in Visual Basic for Applications (VBA)
How to manage and customize Excel functions using Visual Basic for Applications (VBA)
Manage Excel User-Defined functions with Visual Basic for Applications (VBA)
How to customize complex and combined Excel functions using Visual Basic for Applications (VBA)
Understand the For..Next Loop in Visual Basic for Applications (VBA)
The Do,Do..While,Do..Until,While..Wend Loops in Visual Basic for Applications (VBA)
Special Loops in Visual Basic for Applications (VBA): the for each loop, the loop for objects
How to refer to elements of object arrays in Visual Basic for Applications (VBA)
Operators in Visual Basic for Applications (VBA)
Create Math functions in Visual Basic for Applications (VBA)
Logical Operators in Visual Basic for Applications (VBA)
The MOD Instruction in Visual Basic for Applications (VBA)
Conditional instructions in Visual Basic for Applications (VBA)
The IF condition in Visual Basic for Applications (VBA)
IF..Then..Else...ElseIf in Visual Basic for Applications (VBA)
The With Instruction in Visual Basic for Applications (VBA)
How to interrupt the execution of a macro in Visual Basic for Applications (VBA)
The select case instruction in Visual Basic for Applications (VBA). An alternative to the If instruction
Master Excel like never before and unlock the full power of automation with Visual Basic for Applications (VBA). This comprehensive course is designed for beginners, professionals, analysts, and entrepreneurs who want to save time, eliminate repetitive tasks, and build powerful Excel-based applications.
With over 200+ videos, 260+ lectures, and 22+ hours of content, this is one of the most complete VBA courses available. You will learn directly from industry experts who have developed real-world solutions for small, medium, and large companies—working as consultants, managers, and process automation specialists. This means you’re not just learning theory, but practical skills that are immediately applicable in real business environments.
Starting from the fundamentals, you will gradually build a strong understanding of VBA programming, including how to record, edit, and run macros. You’ll overcome the fear of coding by learning the logic behind object-oriented programming in a simple and structured way. Step by step, you will progress to advanced topics such as working with Excel objects, automating reports, handling large datasets, and creating dynamic dashboards and charts.
Throughout the course, you will learn how to retrieve and manipulate data from databases, external files, and web services. You will also discover how to create user forms, automate workflows, build custom tools, and even connect Excel with other applications like Word, Outlook, and Access.
By the end of this course, you will be able to build your own Excel VBA applications, automate complex processes, and significantly increase your productivity and value in any business environment.
Results & Earnings Disclaimer: This course is for educational purposes only and does not guarantee job placement, income, or specific results. Your outcomes will depend on your effort, experience, and application of the skills learned.