vba

Calculate distance between two places in Excel [With Fun]

Dear readers, Last week, As I had placed an article on how to create static google map in excel using Google Static Map API. Over this weekend, I thought of creating some fun for you in Excel using Google Maps Distance Matrix API. This article is going to be a learning with fun or you can say download some fun [...]

get Data Type of Variable in VBA – VarType() VBA function

Dear Friends, Some time during the VBA programming you may need to perform different action based on "what is the type of the variable" you are dealing with. Or in other words what kind of data is stored in a variable. In VBA, if you have not defined type of a variable while declaring it using "Dim statement", then whatever [...]

How to Get Excel version using VBA Code

Dear Friends, Usually while working on any of the VBA projects, it becomes important for me to first check the version of excel which user is using and based on that certain functionality of my tool may or may not work. For Example: If you have some sales data using more than 256 columns then if user is using Excel [...]

VBA Beginners: How to write macro for a Command Button

Dear Beginners, Quite a few times I was getting this question from my readers - How to associate a VBA code to a button? How to write a vba code which gets executed by clicking on a command button in excel vba. Add a button to trigger my macro and so on... Here are 3 simple steps by which you [...]