Hello friends in the last article of VBA Programming Tutorial you have learnt the use of If..else statement. In this lesson you are going to learn another decision making statements in VBA. It means it is another way to control the flow of program, that is nothing but...
Let's take a brief recap of all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learned about all the Controls available in Excel Macros and also how to use...
This Article is going to teach you about Conditional Programming. By Conditional Programming, I mean, the execution of certain statements based on certain conditions. Sometimes in VBA programming, we want to execute certain statements only when a specific condition is...
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...
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.
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]](https://vmlogger.com/excel/wp-content/uploads/sites/11/2019/03/Distance-400x250.gif)
Hi guys, on June 2016, google made some changesaround pricing and authentication etc. of its FREE APIs.Distance...
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 ]](https://vmlogger.com/excel/wp-content/uploads/sites/11/2018/06/40-useful-vba-codes-400x250.png)
Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In a...
