VBA Concepts

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

ListBox VBA Excel Example Macros Codes for Adding new Items,Moving [...]

ComboBox in Excel VBA-Adding new Items,Adding new Items to another ComboBox based on selection of first ComboBox ,Clearing,Example Tutorials and Codes

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

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

In this Section:

• What is a Sub Procedure?
• Calling a Sub Procedure
• Procedures and Access Levels
• Examples on Sub Procedures - With and With Out Parameters
• Example File

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.

Operators and Operands in Excel VBA very useful concept to programming the tasks. Our free tutorials take you through the concepts with examples .

Variables and Data Types in Excel VBA are another important concept to write the programs in VBA for automating tasks. Free tutorial to learn with examples.