VBA Concepts

Home/Tag:VBA Concepts

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

VBA Programming

VBA programming for beginners and advanced users will help you to learn vba programming language and concepts. Our objective of this topic is to provide complete programming reference to write VBA Programs. VBA Programming Learning Objective By learning VBA Programming, you will be able to write VBA programs to automate any task in Micro soft office

By |May 1st, 2014|VBA|14 Comments

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

Interacting with Other Applications using VBA

We can interact with the other applications using VBA - with the MS Office Applications like Word, PowerPoint,Outlook,etc... and other applications like Internet Explorer, SAS,etc.

In this Section:
  • Introduction?
  • How to interact with MS Word? - Late Binding
  • How to interact with MS Word? - Early Binding
  • How to interact with PowerPoint? - Early Binding
  • How to interact with Outlook? - Late Binding
  • Example File

VBA Security in Excel

It is important to understand the macro security if you are dealing with the Macro Enabled Files. It helps to protect your data from the malicious programs and helps to know how to run the macros when its required.

In this Section:
  • Understanding VBA Security
  • What are the different Levels of the Security in VBA?
  • How to Enable or Disable the Macros?
  • How To Protect VBA Code?

VBA Objects Properties and Methods in Excel

Most of the programming languages today are Object Based Or Object Oriented Programming Languages. Although Excel VBA is not a truly object oriented programming language, it does deal with objects.

In this topic:
  • What are Objects?
  • What are Properties?
  • What are Methods?
  • What is Object Browser?

Forms and Controls in Excel VBA

Any Windows Application is equipped with set of objects called windows controls. The Main control is called a Form, it is the primary window contains different types of controls which allow user to interact with the computer. The following is a simple form to calculate square value of a given number.

In This Section:
  • What Are UserForms?
  • What Are ActiveX Controls?
  • What Are The Different UserForm Controls & Use?
  • Practical Learning: Developing A Simple UserForm
  • Example File

Passing Arguments in Excel VBA

We write the procedures to perform certain tasks and some times we may required to write another procedure with small variations. In this situation we can take advantage of the Passing Arguments.

In this Section:
  • What are By Value (ByVal) and By Reference (ByRef) Passing Arguments?
  • Writing a procedure or a function with Arguments
  • How to call a function or a procedure?
  • Example macro file to explain passing arguments

Arrays in Excel VBA

When we work with one item we required to use one variable, if you want work with more than one item, we can go for arrays. Arrays are the variables which allow us to store more than one value.

In this topic:
  • What is an Array?
  • What are the different types of arrays?
  • One Dimensional Array:
  • Multi-Dimensional (Two Dimensional) Arrays:
  • How to Re-size an Array?
  • Array Options
  • Example File

Related pages

unlock excel workbook without passwordunprotect sheet excel vbahow to remove protection from excel sheet 2007lookup function excelsimple vba codehow to find duplicates in excel using pivot tableshortcut key to change the sheet in excelunmergeoffice move checklist template excelcount duplicates exceldelete excel rowsvba paramarray examplecheckbox in excel 2007vba array declarationmake pivot table exceldashboarding in excelexcel 2013 dashboard designexcel macro collectionhypertext link codeexcel formula offsethow do you create a checkbox in excelbuild a macro in excelrange in vbahide cells in excelactivesheet.unprotect passwordexcel 2007 hide columnshow to use autofit in excelvba worksheet deletevba unhide all rowssql questions and answers pdfshow userformvlookup function in vbaunhide excelcolumn index number excelexcel query sqlreference excel cell in vbapivot table excel templateconcatenate function excelvlookup between two valuesremove duplicates in exceltrim excel formulaunhide worksheetsvba code to save excel filesql query tutorial for beginnersinteractive chart excelremove blank lines in exceltrim formula in excelvba loopingshortcut key to insert row in excel 2010vba excel message boxexcel formulas list 2007vbscript sql server connectionunprotect excel sheet passwordddl example sqlexcel vba option buttondifference between two dates in excelexcel macro select rangevariables vbaif statement examples in excelexcel current worksheetexcel dashboard kpicommand button in excelworksheet saveasvba word rangemicrosoft excel insert rowadvanced oops interview questionspivot table excel 2007 tutorialvba insertconvert xml to xlsxvba excel range cellsvisual basic conditional statementswhat do you mean by vlookup in excelexcel 2007 vba macro programminggantt chart excel templatesunprotect macrowhere are excel macros storedvlookup ref errorvba how to select a rangehow to create a pie chart in excel 2013vba sumifs exampleaverage vbamacro security in excel 2007hlookup excel 2010 example