This is a complete guide on Excel VBA. If you’re a beginner user of Excel VBA, you will get your best start here. If you’re using Excel VBA for a long term, there is also something for you. This blog post lists all the step by step tutorials on Excel VBA, 2 most popular Excel VBA courses, all the necessary books (that you can buy from Amazon.com) and a PDF where you will get a huge collection of VBA codes.

“Why I need to learn Excel VBA!” – you might ask yourself.

Let’s start with a personal example

Some months ago, in a Facebook group, someone asked for a help. He wanted to create a system with the following criteria:

The person will order his workbook to create any number of worksheets (the number might be 50, 60 or 100 or any number),

Then, he will provide the name patterns for the worksheets,

And all the above things will be done by just one click.

I helped him out. I wrote a macro for his workbook, he ran it and with just one click he can now do all those things. Excel does not provide any way to do the above things. You have to write code, you have to work with Excel VBA.

My Answer on Quora (How to Learn Excel VBA)

I answered the question with my experience, and so far 933 people viewed the answer and I got 3 upvotes. See the images below and know my way how I command over any programming languages.

My Quora answer Part 1

My Quora answer Part 2

Step by Step Tutorials on Excel VBA

I am gathering here all the step by step tutorials that I wrote to help you learn Excel VBA. Just read the articles one by one and do a little practice. That’s all.

If you don’t have any prior experience in coding, frankly speaking, the topics might seem to you little bit complex. But believe me, if you keep yourself stuck with these materials, you will find it easy and you will start capturing the concepts of programming. Just stuck with these tutorials!

Studies confirm that visuals are processed 60,000X faster in the brain than text.

If you’re a newbie in Excel VBA, I suggest you go with a video course.

It is true that there are plenty of free videos are there on YouTube on Excel VBA, but what you need is a true guide who will start from basic, keep you engaged and on track with lessons, quizzes, and other essential materials.

Daniel also runs a popular course on Excel VBA at Udemy platform, the world’s largest platform for online courses.

After I have joined Udemy as an instructor, I was following Mark Talbert’s this course (Ultimate Excel VBA). I had a plan to make a course on Excel VBA. But after seeing the popularity of Mark’s course, I refrained myself from making the course.

Mark has been using Excel since version 1.0. And here are some reviews in his course.

What are you going to get from this course?

Best Excel VBA Books

In an age of online information, it seems that appeal of books to readers has deteriorated. Started writing a VBA code and did forget the syntax of a constructor? Just go to Google and convert your problems in some phrases and hit Enter. You’re all done.

Millions of results will appear to you immediately.

Searching in a book for some problems? OK. It will take time. Go to Index page, then count a, b, c, d, find out your relevant topic, go to that page, and get an idea of your findings.

A long-term process really and there is no guarantee that you will find your problem topic in your book.

You need one or two books on Excel VBA. It might be in PDF or it can be a hardcover book (preferable).

When you will enroll in an online course on Excel VBA (or on any topic), it is true that you will learn almost all the topics within the shortest possible of time.

But a video course can be compared with a regular classroom where your instructor just gives you the general view and outline of the topics. You then go home, open the book and read the topics that you have learned in your classes and do some practice problems. And you’re all done.

So, still, at this age of quick information, a book is an inevitable asset at your table.

Here, I will give you a list of total 3 books that you can consider buying. These books are really helpful and the readers have shown their high gratitude to the authors of these books through reviews.

I have a database in one folder. Plz Unzip and see all excel files shown datewise. Can anyone help me in extracting day wise data of parameters in format shown in Monthly tracker sheet. Please check the format. It should be like if i select one workbook data from only that one will be extracted, if selected 2 data from one and two both so on and so forth till 31 days. i am uploading the the database and monthly tracker.

please help …. iam in urgent need… thanks in advance plz tell where to post the database zip file

Good day Kawser. I like to download the “1200+ Excel VBA Code Snippets”. If I click the button it forwards me to “subscribe to my blog and get the …….” Since I am all ready a subscriber of your blog and don’t like to subscribe again : Where I can access this or even other useful PDF’s and “Tons of Excel Recsources” ? Thanks for info.. Regards Roger

Dear Sir, I want spin button in my excel sheet to change the items like mango, banana, pattato, ice, tree, cow etc…(it is for teaching in the school)..there are 50 to 55 items ………but it should change in the particular cell not in combobox……..because i have to give the value of that cell to another cell……so will you help me to do this for me……….Please sir ………and please give me the link to my mail id i.e. bhaiswarpravin@gmail.com ……………………please sir﻿

Good morning, I have created a worksheet with columns A through AB. Some columns contain the formulas needed for processing the information that is input and these are summed at the bottom of the columns. Three columns contain checkboxes which are used to activate a particluar column for a calculation. The checkboxes begin on row 3 and exist in column B, C and D. The checkboxes are linked to their respective row in columns Z, AA and AB which is used to test for the state of the checkbox. Periodically, the number of rows with the same layout has to be increased a larger amount of data. I have been trying to find a VBA solution that after clicking a button on the worksheet, a new row is added with all of the relevant formulas and link the 3 checkboxes to the new row at columns A, AA and AB. Since I just discovered your site, am in the process of reading through your material but there is just so much of it and am in need of this solution right away. Can you help?