Dear Friends, In one of my previous article, I explained you about Netherlands BSN Number validation. This used to be called as SoFi nummer (Short form of dutch word - Sociaalfiscaal nummer) as well in the Past. Here in this article, I am sharing VBA code and a FREE...
Results for "button"
VBA to Convert Contact Data in Excel to VCF format
Dear Friends, As you have learned about interacting with Text files through Excel VBA, it is time to see the usage of those methods you learned. One usage, you have already seen here, in how to export excel data in CSV format.In this article, I am going to teach you...
Validate BurgerServiceNummer (BSN) using Excel VBA
Important Note: This post will make more sense to those who stay in the Netherlands. Also do not forget to download the BSN validator tool created at the end of the post. It is FREE to download and play around with. Thanks. But wait.. even if you do not stay in the...
Archives
Buy a coffee for the author There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire...
Privacy Policy
Your privacy is important to us. It is Learn Excel Macro's policy to respect your privacy regarding any information we may collect while operating our website. Accordingly, we have developed this privacy policy in order for you to understand how we collect, use,...
Terms & Conditions
Terms & Conditions Terms By accessing the website at https://vmlogger.com, you are agreeing to be bound by these terms of service, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws. If you do not...
What if you do not have internet ??
Wait.. this is supposed to be an Excel Blog.. right? Then why such article here? Am I going to discuss about this biggest problem of the World 😉 i.e. Internet Not Working?? Or Have I got some excel macro which will fix your Internet Connection problem. Or an Excel...
VBA to Add Static Google Map in Excel Sheet
Dear Readers, In this article, I am going to give you a quick tip - how can you add google map in your excel workbook without opening the google map in any browser. More details about this will follow... To do that I am using Google Static Map API. I am not going...
Windows FileDialog to Select File or Folder Path in VBA
Dear friends, In my many Excel Tools, wherever there is a need for a file path to be entered from your local PC, I try to put a browse button to locate that file in your Windows PC through the windows file explorer window. It is the same window that you might have...
Excel Tool : Folder Structure Creator
Dear readers, In my previous article I posted an article about how to create folder in windows by Excel VBA code. That triggers me to build an Excel tool to create a hierarchical or Tree folder structure in any directory which is defined by you in excel sheet. Before...
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...