Monthly Archives: August 2013


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

By |August 25th, 2013|Excel VBA|1 Comment

ListBox in Excel VBA – Adding, Clearing, Multiple Selection Examples

ListBox VBA Excel Example Macros Codes for Adding new Items,Moving all Items, selected Items from ListBox to another ListBox,clearing,Multi selection. VBA ListBox in Excel is one of finest control in the Excel. You can show the list of items in the listbox and user can select any item and do different operations. In this tutorial,

By |August 24th, 2013|Excel VBA|21 Comments

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

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

By |August 11th, 2013|Excel VBA|6 Comments

Related pages

access vba run macroconsolidate spreadsheetshow to unlock a excel file protected by passwordmerging columns in exceleasy vlookup examplevlookup col_index_numadvanced vba courseexcel string containsstacked column chart excel 2007vba array uboundhow to add extra rows in excelexcel unhide all sheetssql select excelexcel unprotect sheetsas interview questions pdf free downloadrange function vbaexcel macro tutorial pdfexcel macro open worksheetvba integerunhide column a in excelcreate excel drop down list 2007coding macros in excelmeeting minute template wordexcel programming basicsproject schedule template powerpointmpp microsoft project plan free downloadbubble charts excelnested ifs excelvb programs examplesexcel vba dim arrayhow to learn vlookup in excel 2007vba current directoryiferror excel vbaarray in excel vbabasic vba commandshow to delete lines in exceldouble vbainteger function excelinsert function vbaconsolidate excel workbooksproject management spreadsheet excel templatems access vba message boxif statement vbamatch vbaredim multidimensional array vbavariable types in vbavba inputboxsql interview question for freshervba macro excel examplesdevelopers tab in excelreference excel cell in vbaexcel macro save filevba special charactersvba excel progress barunprotect excel without passwordteam capacity planning xlsexcel hide rowsvba ebookpivot table 2010 tutorialhide excel formulasexcel vba current sheetpricing model template in excelhow to create bar chart in excel 2007create dashboards in excelvba combobox excelformula to remove special characters in excelhow to find duplicate values in two columns in excelaccess 2010 vba recordsethow do i insert a column in excelrefresh all pivot tables vbaexcel filter duplicate rowshow to lookup in excelexcel vba refreshddl languagerept function exceladodb connection string sql server 2008how to find developer tab in excel 2010dim excel vbaadvanced excel 2007 tutorial pdf