Welcome to vmlogger.com
Thanks for visiting this website. This blog is meant for sharing knowledge about Microsoft Excel, especially VBA (Macro) – Visual Basic for Applications.
Always open to receiving feedback about my articles… there is always a possibility of improvement !!
Hope you will enjoy reading this blog and get benefits.
About this blog
Story – How it all started
I was working as a Software Test engineer in one of the leading Indian IT firms in Bangalore. I started my career as a Manual Tester. And not liking manual testing was no exception. The first project that I was involved in had to deal with lots of Management and Project data handling resulting in lots of Excel sheets and numerous trackers. Back in 2007, I was not even introduced to “Excel Macros” or “Excel VBA”.
To be honest, I used to get surprised seeing the automated stuff in excels with a click of buttons. My assumption was that these were Microsoft customizations available. Out of my curiosity, I asked one of my senior and he showed me the code behind those buttons. That was my first interaction with VBA.
That was another surprise… Oh my god, behind those excels sheets there was another place where you can write so many lines of code? I was amazed and started going through those existing “trackers” in my project and codes behind them. Took help from Microsoft Excel help and Google. In no time I was so fascinated and developed so much of interest that I used to wait for my office hours to get over so that I could start reading more and more about macros. And in no time I built my first macro.
As time progressed I had built many useful tools in excel for my project and my learning and creativity curve rose since then
A fine day it occurred to me to start a blog and publish these small pieces of codes and tools that I had and which might also help others users, especially beginners like me. I, then, created a blog on Google’s Blogspot.com.
Later that year, I registered a domain with the name which came first into my mind “LearnExcelMacro.com”. This is how this domain was born. I initially started posting code snippets, tips and tricks related to Excel and Excel VBA.
And today, you can find numerous helpful tools, articles, videos, VBA book for beginners.
Subscribers
Articles
Downloads
Tools & Templates
Expectation
What can you expect here?
I try to keep my articles in a very simple language and “To the point”. Most of the articles will have necessary images, diagrams, code snippets and sample Excel files to download.
Every article, tool and template available here is based on my research as a user when I started as a beginner. So, I hope you will have a good experience reading my articles and using freely available tools and templates.
But as they say, there is always a room for improvement. So your feedback is always welcome and appreciated.
250+ Articles [Posts]
More than 250 articles related to excel VBA.
Exercise File to Download
Most of the articles, has a downloadable file for you to practise that particular topic
Code Snippets, Images, diagrams etc.
Each post has necessary code snippets, diagrams and screenshots.
20+ Free Tools/templates
There are more than 20+ tools and templates available to download for free.
Recommended Pages
Recommended Tutorials
Automate sending email via Excel VBA
Enjoy several tutorials and articles for sending email via Excel VBA. You can be able to download some amazing tools as well for sending emails.
User Defined Functions in Excel
Didn't find a formula which you wish to have in Excel? Don't worry, create your own formula to use it in your excel sheets.
Excel VBA tutorial for Intermediate
Some amazing tutorials for intermediate level excel vba learners.
FREE Downloads
Download some amazing tools and templates in order to improve your productivity at work.
Beginner's Page
Excel macro tutorials for beginners. Learn basics to start with your excel vba journey.
HP Quality Center - VBA Codes
Download and read so many amazing piece of vba codes in order to automation HP QC related tasks, reporting etc.
VBA Programming
Learn programming concepts related to Excel VBA with sample code and illustrative images. You will learn here about For Loop, While loop, Do While loop, If else, Switch, etc.
Databases - via Excel VBA
Want to connect to a Database via Excel VBA Code? Run any kind of query like Select, Update, Delete, Insert via Excel VBA? This series of articles will explain you in a very detailed manner.
Join Today & GET a FREE e-Boook!
With over 50,000+ readers and counting Join NOW and get a FREE E-book to download !!
Expectation
How do I help you learn?
VBA Code snippets
Useful VBA code snippets readily available to copy paste and run
Beginner, Medium, Advance
Excel VBA tutorials for all readers. Beginner, intermediate and advance.
Categorized Tutorials
Tutorials are categorized based on specific topics such as dealing with files, sending email etc.
FREE Tools and templates
Useful Excel Tools (FREE Download) developed using Excel VBA
VBA Functions & Formulas
Important excel Formulas and VBA functions
Tips & Tricks
Day to day useful tips and trick
Helping hand
People who help me running this site
My partner in crime… Shagun, she supports me in all way to do this
Non Technical Reviewer
Review and editing of all non-technical contents on the site. Because my writing skill sucks 😉
Support
Allow me to spend some time at home doing this activity apart from my 9 to 5 full time job. I thank her for that
Designer
Help me in designing the new layout, look & feel of this blog.