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….Read full article…

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….Read full article…

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….Read full article…

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.  ….Read full article…

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….Read full article…

As we saw in the Previous Article you learnt How to use Drop Down Box in Excel   If you want to read more about Excel Macro… visit Excel Macro Tutorial   In this Article you will learn How to Use ListBox in Excel. It will include   1. Adding Items in Excel ListBox 2.….Read full article…

Hello Friends,   It’s been long time, i posted any article :(. Today I am going to write about Combo Box in Excel. At the end of this Article, you will be able to use Drop down in Excel. It will include   1. Adding Items in Excel Combobox dor Excel Drop Down 2. Removing….Read full article…

How to use Progress Bar in excel Macro (VBA) Progress bar is nothing but a placeholder, where you see the Progress of the operation which is getting performed. Like Visual Studio there is NO already built progress bar in Excel Macro (VBA), which you can use it as an object and it will act like….Read full article…