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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney


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

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics