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.
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.
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?
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.
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
Excel Shortcut keys help you to do your tasks faster and you will find more comfortable while working with shortcut keys, instead of mouse.
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.
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 - formula returns the number of days between two dates based on a 360 day year. Learn Formulas, Excel and VBA with examples.
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.
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.
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 .
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
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 is a feature available in Excel to define restrictions and what data can enter in a cell. For example,
- We can restrict data entry to a certain range of values
- User can select a choice form predefined list
- We can display a message to provide the instruction to the user
- We can display a message when user enter an incorrect value
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
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.
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
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.
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?