120+ Professional Project Management Templates!
Project Management Templates

VBA Concepts

VBA concepts help you to understand the programming techniques of VBA to master in macro programming language for MS Office Tools.

Introduction to Collections in Excel VBA


Collection is an object contains group of objects having similar characteristics (with same properties and methods). For example,if you want to loop through all worksheets in a workbook, you can refer worksheets collection of the workbook and do whatever you want to do with that particular worksheet.

In this topic:
  • Introduction to Collections?
  • Collections in Excel VBA
  • Examples Macro File On Collections
Introduction to Collections in Excel VBA2022-06-17T03:55:31+00:00

ADO in Excel VBA – Connecting to database using SQL


ADO Stands for ActiveX Data Objects, is Microsoft’s Client-Server technology to access the data between Client and Server. ADO can’t access the data source directly, it will take help of OLE DB Provider to communicate with the data source. Most of the times OLE DB providers are specific to a particular Data Source Type. However, we have an OLE DB provider for ODBC, it is a general purpose provider with help of this ADO can access any Data source which can understand ODBC.

In this topic:
  • What is ADO?
  • What is Database?
  • What is SQL?
  • Practical Learning: Using ADO and SQL with VBA
  • Example File
ADO in Excel VBA – Connecting to database using SQL2022-12-19T15:45:12+00:00

Events in Excel VBA


Event programming is the most useful tool which helps to monitor specific user actions within Excel. For example, if the user Opening a Workbook, Selects a Worksheet, enters data into a Cell, or saves a Workbook, these actions are all Excel Events.

In this topic:
  • What Are Events?
  • What Are The Different Types of Events?
  • Practical Learning: Workbook_Open Event
  • Example File: Workbook Events, Worksheet Events and Form Events
Events in Excel VBA2022-06-17T03:55:43+00:00

Conditional Statements in Excel VBA – If Else, Case, For, Do While, Do Until, Nested Ifs


Conditional statements in Excel VBA helps to control the programming. Learn IF,If Else, Nested If, Case, For, Do While, Do Until statements with examples.

Conditional Statements in Excel VBA – If Else, Case, For, Do While, Do Until, Nested Ifs2022-06-17T03:56:02+00:00
Go to Top