Who am i? My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor’s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience. In 2014, I married my Love, Shagun and we are living...
Results for "fun"
Home
Are you new to Excel macro? Do you want to learn Excel VBA? This is the right place for you to start with. A step-by-step tutorial for beginners, medium and advanced.
Happy to help – A Quick Update
I hope you are all doing well in this amidst corona pandemic period. As Take care of yourself and near and dear ones. Stay home as much as possible. Take all the precautions suggested by the Health Organizations (WHO, local health orgs, government bodies etc.) when...
Distance Calculator in Excel VBA [REVISED]
Hi guys, on June 2016, google made some changesaround pricing and authentication etc. of its FREE APIs.Distance calculator API was also affected by those changes. I had written an article long back about how to calculate distance and time taken between two places in...
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 means, simply, by using a formula in excel, I could Spell Numbers in Words. In banking or accountancy, this is used to write grand total amounts....
Early Binding v/s Late Binding in Excel VBA Programming
Early and Late Binding is a common phenomenon across computer programming languages. In simple terms, Binding means - how and when methods or properties of an Object are compiled and checked. In the case of Excel VBA [COM - Component Object Model] - this occurs when...
Regular Expression and its usage in Excel VBA
Dear Reders, In this article, I am going to teach you What is Regular Expression (RegExp or RegEx)? and how RegEx is used in Excel VBA programming. You will also learn the usage of Regular Expressions in Excel VBA with some example VBA code. You can also find some...
40 Useful Excel Macro [VBA] examples – Part 1 of 2
Dear Friends, Here in this article, I have tried to consolidate some most useful and more frequently used excel macro with examples. This is part 1 where I have provided 20 Excel Macros related to workbooks and worksheets. Remaining 20 Excel Macro examples will be...
5 rarely used features in Excel VBA
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...
Do you want to be part of my Next article?? … Here you go…
Dear Readers, In my next article, which will be published next Monday, I am going to cover following two topics: 5 Interesting but rarely used features/functions in Excel/Excel VBA 5 Interesting facts about Excel [from history...] Before I publish these articles, I...
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 (=).
Excel Tip : How to Make an Excel Cell secured for Password
One of my friend wanted me to write an article on How can a person achieve making an Excel Cell behave like a password...
Spreading data across Columns in Excel Without VBA Code
In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to...
Read and Write Document Properties of an excel Document – VBA
In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to...