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

how to unlock an excel filevba rsdashboard tools for excelchange the row height in excelvba save excelhow to unprotect excel sheet 2007vba access msgboxnested vlookup in exceldelete worksheet excelexcell find duplicatesremove duplicates vbaexcel vba eventsminute templates for meetingsshortcut for hyperlink in excelvba squareinfosys interview process for experiencedexcel formulas lookupuserform in excel 2007nested vlookup excelddl dml statementsworkbooks closeunprotect excel workbook 2010 with passwordname range in excel 2007vba create fileanalyst programmer interview questionsexcel vba borderaroundexcel vba range objectexcel copy row to another sheetmerge and centre excelsales dashboard excel templatepivot table advancesql interview questions and answers for freshersdcl tclexcel hide tabsfrequently asked interview questions and answers for freshersactiveworkbook.saveasexcel vba reference cellworkbook close vbaexcel macros password removervba programming excelvba expertaccess vba msgbox yes novba programming in excelexcel duplicate cellsvb code examplesadvanced excel macrosvba excel formulasvba load excel fileconditional statements worksheetstatus update template powerpointnested if statements excel 2010how to combine data from multiple worksheets in excel 2010vba activex controlsdata entry form in excel 2007excel quick tutorialschedule template powerpointvba application.displayalertsunprotect sheet with passwordhow do i unhide rows in excelscheduling in excel templateexcel change column to rowvba application calculationexcel macro isnumberexcel remove empty cellshow to use sumif formula in excel 2010vba adodb recordsetexcel password sheethow do you delete duplicates in excelvba sample codevba to create pivot tableexcel delete blank columnshow to delete blank cells in excelexcel macro recordingunderstanding excel formulasvba user defined functiondebug.print vbaexcel vba option buttonsvlookup 2 criteriaexcel bubble chartvba excel isempty