Monthly Archives: April 2012

VBA Programming : String Manipulation

Many a times, we come across to deal with Strings. Like Length of the String, Concatenating two or more Strings etc. This article teaches you how to deal with strings with the following different operations: 1. Concatenating Strings (Joining Strings) 2. Finding Length of a String (Len Function) 3. Remove Spaces from a String (Trim Function) 4. Left Function 5. [...]

VBA Programming : If Then Statement

This Article is going to teach you about the Conditional Programming. By Conditional Programming, I mean, execution of certain statements based on certain conditions. Sometimes in VBA programming, we want to execute certain statements only when a specific condition is met. If Then Statement helps you achieving this. Now we will discuss about all aspects of If Then Statements. We [...]

VBA Programming : Variables in VBA

Just like other programming Languages, Excel VBA also uses different types of Variables. This Article teaches you following Topics:   1. What is Variable ? 2. Importance of Variable in Excel Programming 3. Important Rules of Variables, you must know, before declaring a Variable 4. Different Types of Variables 5. How to Declare / Initialize and Assign value to a [...]

Assigning Macro : How to assign macro to Hyperlink ?

So far we have always seen running any Macro or Function using a Command Button. Sometimes, instead of putting a Command Button, you want to do the same operations but by using a Hyperlink in Excel. In this article you are going to learn how to run a macro by using Hyperlink in Excel.   Follow the below Simple Steps [...]

User Defined Function in Excel to Convert Currency to Words

Many a times we require to change the Numbers in Words. For Example: 6734862=Sixty Seven Lakhs Thirty Four Thousand Eight Hundred Sixty Two. In Excel, there is no Formula as such to Convert Numbers in Words. I have written one UDF : User Defined Function. After using this Function, you will be able to change any numbers in Words. Now [...]