This Article is written for the people who does not know about Excel formula. This article answers following questions about Excel Formulas: 1. What is Excel Formula? 2. How to Use Excel Formula - a step by step tutorial. 3. How an Excel Formula works in Excel?...
Results for "while"
Allow Cell Drag and Drop Option in Excel 2003, 2007 and 2010
Hi Friends, Before I go and explain you how to enable or disable drag and drop option in Excel, let me explain you what is Drag and Drop Option in Excel. What is Drag and Drop Option in Excel ? When you select a Cell in Excel and roll your mouse to the Right-Bottom...
Download : Excel Macro Application to Send Multiple Emails
Hello Friends, I was getting queries on : How to send Email from Excel ? How to send Email from Gmail in Excel Macro ? How to Send Email from Yahoo in Excel Macro ? How to send email from Outlook in Excel Macro ? How to send Multiple emails using Excel Macro ? Keeping...
Entering the Current Date into a Cell
Sometimes while dealing with Excel Workbook, you may need to fill a Cell with the Current Date. In such a case, you need to change the Cell Value every day with the current date. Using the below small trick, you can make it automated. It means the Cell will be always...
How to get Excel Range in Array
Many times while developing an application in Excel VBA, we need all the values stored in an excel Cell Range in an Array variable. So that at any point in time we can access the value from the array, rather than going to Excel Cell and reading it from there. Also,...
Excel Macro Tutorial : Excel Form
In this article, I am going to explain every aspect of the VBA Form. User forms in Excel are really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this article, you are going...
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...
VBA Programming : Variables in VBA
Just like other programming Languages, Excel VBA also uses different types of Variables. This Article teaches you the following Topics: 1. What is a Variable? 2. Importance of Variables in Excel Programming 3. Important Rules of Variables, you must know, before...
User Defined Function in Excel to Convert Currency to Words
Many 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 into Words. I have written one UDF : User Defined Function. After using...
Excel Macro Tutorial : How to Use ListBox in Excel
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...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
FREE Download : Send Multiple Email Tool – Ver 3.0
First of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email - VBA...
Spreading an Array values across Rows in Excel – VBA
This is an extension to my previous Article. Where we learned the best way to spread array values across columns in...
Spreading an Array values across Columns in Excel – VBA
All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming...