# Monthly Archives: May 2013

## YEAR Function in Excel

YEAR Function in Excel - formula to returns the year of a date. Learn more Formulas, Excel and VBA concepts with examples explained in our free tutorials.

By |May 30th, 2013|Excel Formulas|0 Comments

## SECOND Function in Excel

SECOND Function in Excel - formula to returns the second, a number from 0 to 59. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |May 27th, 2013|Excel Formulas|0 Comments

## 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?

By |May 26th, 2013|Excel VBA|9 Comments

## MINUTE Function in Excel

MINUTE Function in Excel - formula to returns the minute, a number from 0 to 59. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |May 25th, 2013|Excel Formulas|0 Comments

## 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

By |May 25th, 2013|Excel VBA|6 Comments

## Excel Shortcut Keys

By |May 24th, 2013|Excel|1 Comment

## HOUR Function in Excel

HOUR Function in Excel - formula returns the hour as a number from 0 to 23. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

By |May 21st, 2013|Excel Formulas|0 Comments

## Copying Moving and Pasting Data in Excel

Learn how to copy, move and paste the data in excel. This tutorials are explained with proper examples with screen shots.

## DAYS360 Function in Excel

DAYS360 Function in Excel - formula returns the number of days between two dates based on a 360 day year. Learn Formulas, Excel and VBA with examples.

By |May 20th, 2013|Excel Formulas|1 Comment

## Change Row Height and Column Width using Excel VBA

This example will show you how to change row height in excel using VBA. Learn more about VBA and related topic here with examples, Files and explanation.

By |May 18th, 2013|Excel VBA|4 Comments

## Formatting Data and Formatting Cells in Excel

This tutorial will help you to learn Formatting Data and Formatting Cells in Excel. We can format the numbers, fonts, background and many more things.

By |May 18th, 2013|Excel|1 Comment

## DATEVALUE Function in Excel

DATEVALUE Function in Excel - formula Converts a date represented by text to a serial number for a date. Learn Formulas, Excel and VBA with examples .

By |May 15th, 2013|Excel Formulas|0 Comments

## Write Data to Worksheet Cell in Excel VBA

Description: In the previous post we have seen, how to read data from excel to VBA. We will see how to write data to Worksheet Cell in Excel VBA. Write Data to Worksheet Cell in Excel VBA - Solution(s): It is same as reading the data from Excel to VBA. We can use Cell or

By |May 15th, 2013|Excel VBA|28 Comments

## Entering Data and Moving in Excel Worksheet

Entering Data and Moving in Excel Worksheet is very easy . You can enter any numbers, text, dates in Excel and you can format as per your requirement.

## 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

## 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

By |May 12th, 2013|Excel VBA|2 Comments

## Change Font Color in Excel VBA

Examples will show you how to change Font Color in Excel using VBA. While preparing the reports we change the font colors based on data Or a template.

By |May 11th, 2013|Excel VBA|4 Comments

## 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

By |May 11th, 2013|Excel VBA|3 Comments

## Read or Get Data from Worksheet Cell to VBA in Excel

It is very simple to Read or Get Data from Worksheet using VBA, There are may ways to read the data from Excel to VBA. See the examples explained Here.

By |May 10th, 2013|Excel VBA|62 Comments

## Introduction to Excel Interface and Objects

We have seen what is Excel and what we can achieve using Excel in the previous section. I n this section we will what are the different objects in Excel to do our jobs and piectorial representation of Excel Interface. In This Section:

• Introduction to Excel Interface
• What are the Objects in Excel?