Good Excel VBA Macro Tutorials


New Member
Oct 10, 2009
I'm looking for some good Excel vba and macro tutorials - preferably video tutorials since I just can't stand most of the books I've read on the topic. I've heard about the mr excel vba and macro for excel book, is that any good.

Also, what about an online video tutorial solution like the one offered from I haven't found many other sites that even attempt to teach vba through video tutorials; does anyone have any ideas or opinions about trying that site? (link for it is below)

Thanks in advance for any ideas, really trying to bone up on my vba so i don't have to keep coming back here all the time ;P

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.


Well-known Member
Apr 8, 2009

Training / Books / Sites:

How to Learn to Write Macros

How to use the macro recorder

Click here and scroll down to Getting Started with VBA.

If you are serious about learning VBA try

Excel Tutorials and Tips - VBA - macros - training

See David McRitchie's site if you just started with VBA

Debra Dalgleish has some notes how to implement macros here:

David McRitchie has an intro to macros:

Ron de Bruin's intro to macros:

Creating custom functions

Writing Your First VBA Function in Excel

(livelessons video)
Excel VBA and Macros with MrExcel
ISBN: 0-7897-3938-0

Dependent validation lists. Debra has a neat little tutorial here.

Cascading queries

Excel Data Validation - Add New Items

Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.

Locating files containing VBA
Searching Files in Subfolders for VBA code string:

Excel 2003 Power Programming with VBA, by John Walkenbach

VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad

Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley

VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad

Excel 2007 Book: you can try this...there is a try before you buy ebook available at this link…

DonkeyOte: My Recommended Reading:




Pivot Intro

Email from XL - VBA

Outlook VBA

Function Dictionary

Function Translations

Dynamic Named Ranges

And, as your skills increase, try answering posts on sites like:

Where to paste code in VBE VBA
Introducing the Excel VBA Editor

VBA for Excel (Macros)

VBA Lesson 11: VBA Code General Tips and General Vocabulary

Excel VBA -- Adding Code to a Workbook

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...