Monthly Archives: August 2013

Home/2013/August

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


excel vba substitutevba macro codepowerpoint bubble chart templatelistbox selectionusing nested if in excelexcel macro tutorial for beginnersexcel vba string containsdigital dashboard examplesunprotect excel workbook 2013step by step pivot table excel 2010sumif functionspowerpoint macro tutorialclient tracking excel templatehow to alphabetize in excel 2003sas and sql trainingsimple explanation of vlookupmacros vbahow to write an if statement in excelhow to protect spreadsheet with passwordmessage box in vb6autofilter in vbavba array excelworksheet protection exceldelete duplicate values excelexcel macro vba tutorialexcel 2010 unhide worksheetvba close formms access vba code examplesexcel vba onloadexcel vba programming tutorialexcel vba pivotvba outlookvba open workbookrefresh all pivot tables vbadelete blank cells in excelhow to find duplicate values in two columns in excelcountif examplespider web graph excelhow to do data validation in excel 2007how to create a combobox in excel 2010excel vba screen updateexcel 2010 vba editorexcel collection vbawhat is a vlookup functiongoto statement vbacombine multiple spreadsheets into oneexcel vba constantlearn macro in excelvbscript to delete files in a folderselect case vba excelunlock excel worksheet without passwordmerge multiple sheets into onems excel project plan templatevba goto celljob tracking spreadsheet templatehow to dedup in excelexcel for begginersspreadsheet control vbaexcel vba unload meexcel vba recordsetvlookup excel step by stepfree excel userform templatesdelete a row vbawhat is pivot chart in excelexcel interior.colorindexunlock password in excelmicro in excel 2007hlookupdeleting duplicates excelrun macro vbaweekly report template pptintegrated master schedule templateexcel concatanateexcel worksheet name from cell valuefor loops excel