Dear friends, As promised last week, in this article, I am going to talk about 5 rarely used features of Excel VBA. [I am not saying that all of these features are awesome to use... I have provided my personal choices for each of them] 1# Using IIF in Excel vba IIF is...
Results for "reference"
How to find Visible Range in Excel window on a Screen
Dear Friends, Its been a while I posted any post here. I am back with so many interesting stuff for you in Excel VBA. Here is a very small but useful excel vba tip for you. This is about knowing the range which are currently visible to the user on his/her screen. Do...
Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2
This is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). Bit of a Story about this...
VBA String Functions – INSTR() Function
Instr() Function This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer...
Excel OFFSET Function – Excel Tutorial
Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference which is offset a number of Rows and Columns from a specific Cell or range. Most importantly this is a function which returns Range Address and not the...
Input Box and “Smart” Input Box
The most easiest and commonly used function in VBA is Input Box. Without much VBA coding, user can be asked to enter some input at any point of programming. To illustrate the simplicity of Input Box we will take an example. Example: You are trying to add a New...
Excel Formula : DATE and TIME Formula
Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page. Click on the below links for to know about all these Formulas and how to use them DATE | DATEDIF | DATEVALUE | DAY | DAYS360 | HOUR | MINUTE | MONTH | NOW | SECOND |...
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...
DATEDIF Worksheet Function : Age Calculation
In this Article, I am going to explain you, how can you use DATEDIF() Function and also using this, how can you calculate Age in Excel. Basically DATEDIF calculates difference between two dates. The most interesting part of this Function is that you can calculate the...
How to interact with HTML pages from Excel
In this article you are going to learn how to interact with HTML pages from Excel Macro/VBA. Though Excel is not much capable and easy enough to interact with HTML pages and its HTML controls. But up to some extend we can interact with HTML pages by Excel Macro. To...
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 (=).
Distance Calculator in Excel VBA [REVISED]
Hi guys, on June 2016, google made some changesaround pricing and authentication etc. of its FREE APIs.Distance...
UDF to Convert Numbers to Letters
First of all, wouldn't it be great if we have a built-in function in Microsoft Excel to Convert Numbers to Letters? It...
40 Useful Excel Macro [VBA] examples – Part 2 of 2 [ FREE DOWNLOAD ]
Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In a...