Monthly Archives: May 2013

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

Data Validation in Excel – Adding Drop-Down Lists in Excel

Data Validation is a feature available in Excel to define restrictions and what data can enter in a cell. For example,

  1. We can restrict data entry to a certain range of values
  2. User can select a choice form predefined list
  3. We can display a message to provide the instruction to the user
  4. We can display a message when user enter an incorrect value

By |May 12th, 2013|Excel|0 Comments

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


how to write an if statement in excelhow to colour duplicates in excelmicrosoft project timeline templateexcel tutorials for beginnersnamed ranges vbaoffset function in vbavb nested ifusing concatenate in excelsales trend analysis excel templateexcel 2007 sort by dateunhide all columnsvba coding in accessexcel null checkcombine columns in excel 2007column width excel vbamysql oledb connection stringvba excel tablecreating a hyperlink in excelgetopenfilename vbaautofit excel 2010combobox in excel 2007cell color excel vbajoin rows in excelvba listbox sortdir vbaadd the developer tab to the ribbon in wordvba excel isnumbervba code tutorialif iserror formulaunlock a password protected excel filewww vlookup formula excelvlookup returns 0make pivot table excelmultiple if and statements in excelexcel 2010 delete duplicateshlookup excel functionexcel concatinationaccess vba run querycomplex if statements in excelvba check boxrange command vbavba object browsercopy sheet excel vbasimple excel test for interviewunderstanding excel formulas and functionsexcel vba userform tutorialexcel advanced filter criteria examplesvbscript write to text filevba procedurems excel count functionvba step by step runmicrosoft excel vlookup tutorialwhat does vlookup mean in excelexcel change background color based on valuerange.find vbafollow hyperlink vba excelvlookup and hlookup tutorial pdfhow to activate activex controlcoding calculatorexcel 2003 vbasas tutorial pdf beginnersopen xlsx with excel 2003vba excel copy worksheetexcel formulas sumifvba create foldermeaning of vlookupexcel pivot table example datahow to lock and unlock cells in excelvba sql wheregantt project planner excel templatevba exit formexcel macro lookupexcel copy cell to another sheetexcel vba macroif functions excel 2013sort macro excelprotect sheet macro