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


write if statement in excelvba syntax guidevba save excelmacros basicshow to do data validation in excel 2007excel developer ribbonexcel team schedule templatehow to insert multiple rows in excel 2007saveas vbaloops in excel vbaexcel formulas average ifestimating spreadsheet templatevba insert picturevba case syntaxexcel vba internet exploreradd developer tab to ribbon word 2013sample pivot tableshow to do a pivot table in excel 2007copy worksheet to another workbookmacros and vba in excelusing the vlookup functionexcel equality testturn on macros in excelarray vba excelrows count vbahow to find blank rows in excelleft in vbahow to use excel sumifapplication in vbahow to highlight column in excelsave as filename vbaconsolidate excel worksheets into oneworkbook passwordexcel vba set cell colorpopular excel macrosexcel combine duplicate rowsunhide column excelhow to shift columns in excelexcel record a macroinput box in vbadelete rows in excel using vbafso copyfileif function in excel 2007 with examplehlook up excelexcel trim commandexcel insert rowshow to unlock an excel fileactivecell interior colorindexwhat is hlookup in excelsumif excel tutorialusing functions in vbaexplain vlookupexcel charts examplesdelete duplicate row in excelexcel vba code librarypivot table example in excel 2007how to write a vba codecall function vba excelvba save excel filesas macros for beginnerswhat is grouping in sqlvba excel arraysexcel 2010 sumif examplevba dropdownhow to create a named range in excel 2010lookup functions excelexcel macro referencesample dashboard reports in excelvba insertwriting vlookup formulas in exceldatediff vbahow to find duplicate rows in excel