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

h lookup formula in excelexcel remove duplicates in a columnadodb connection examplems access 2007 vba programming tutorial pdfhow to lock a spreadsheetexcel vba msgbox inputexcel data analysis for dummiesfind duplicates in excel spreadsheetvlookup left to rightexcel remove blank linesexcel vba rangevba color index numbersmysql oledb connection stringhow to unlock formulas in excelexcel duplicate countusing vlookup in excel 2010compile excel vbahow to unhide top rows in excelexcel concatenate sheetsdynamic dashboard template in excelhow to use excel vlookup functionvba excel cellsample charts in excelhow to remove unwanted rows in excelhow to use hlookup in excel 2013vba excel concatenateproject charter template powerpointsort vbaexcel vba worksheet copyexcel vba redim preserveinsert a column in excelhow to remove excel formulaexcel remove all blank rowsdefine vbaabout genpact interview questions and answersuserform vba excelconsolidate in exceltrim function excelms excel functions with examplesvba recordsetexcel combine worksheets into one worksheetautofit excel vbaadvanced sql interview questions pdfhow to sumif in excelbubble chart template excelexcel vba getsaveasfilenamedelete rows in excellook up formula in excelvba loop syntaxadvanced excel formulas with examples in excel sheetvbcr vbadeveloper tool in exceldata entry form in excel 2007how to shift columns in excelvb code examplesexample of vlookup in excelsas eg tutorialvba average functionform controls vs activex controlsexcel sheet delete shortcut keyexcel vba chart typeshow to add the developer tab in excelread text file vbatechnical interview questions and answers for freshersunshare workbookunlocking excel filescombine multiple worksheets into onetwo dimensional array vbaexcel filter based on cell valuemerge cells excel