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

excel formulas countifunlock protected excel spreadsheetmacro remove duplicatesvba excel combo boxproject budget spreadsheet templatevba insert multiple rowsdeveloper tab in excel 2010convert excel file to xmldelete duplicate cells in excelvba case selectiserror vlookup excelfunction sumifexcel macro database querygrant sql commandvba code wordbasics of sas programmingbuilding excel dashboardsexcel vba interior colorunprotect excel vba project passwordif vlookup examplehow to remove duplicates from two columns in exceldata definition language commands in sqlcompile excel vbahow to erase duplicates in excelhow to unlock excel workbookadding multiple columns in excelexcel macro copy row to another sheetvb sample programs beginnersvba range objecthow to insert macro button in excel 2010free capacity planning template excelvba select sheetconsolidate workbooks in excelcreate userform exceloffset command excelsql questions for freshersestimating excel templatehow to run sql query in excelvba expertshow to write macros in excel 2007excel vba tricksexcel calculate sheet shortcutshortcut key to delete a row in excelprogram dashboard templatexls to xml conversionhow to change width of column in excel 2007vlook up formulaopen and activate workbook vbahow we use vlookup in excelexcel mysql queryhow to delete duplicates on excelexcel vba application.getsaveasfilenamecylinder chart in excelvba file nameexcel 2007 calendar templatehow do i unlock an excel fileexample vlookupvba copy rowcopy worksheet vbavba msgbox examplesexcel vba screen updateproject planner freewareexcel 2007 dashboard examplesvba code for checkboxfree excel 2013 add insdelete column vbaexcel vba chrbasic macro excelexcel macros tutorialsvba tutorialsdelete function in excelhow to delete sheets in excelexcel vba activate workbookcombine tabs in excel