New to Excel Programming and looking for learning materials

**joyofmanygenerations** · 04-07-2012, 04:12 PM

Hello

Please I am new to excel programming and would like to get started.

Can anyone help me with basic study materials for a beginner.

Mod Edit (10 August 2018):

PLEASE NOTE:

This thread is a sticky as it has become a compendium of useful links and resources for members to use to learn VBA.

You may post to this thread ONLY if you have a new resource to add to the list (this must NOT include advertising links - see our forum's rules).

If you wish to thank anyone who has contributed to this thread, please do so using the reputation system by clicking on the star to the bottom left of one of their posts and leaving a 'thank you' message. Any 'thank yous' or other 'noise' posted to this thread should be reported and will be deleted. This is so that the thread remains clean and easy to navigate for all.

Thank you all for your co-operation.

**stanleydgromjr** · 04-07-2012, 04:41 PM

Latest update from Stan (thanks Stan)
See if something, in the below link(s), of my most up to date list will help you:
Training / Books / Sites as of 2/3/2018

What Is VBA?
https://www.techwalla.com/articles/what-is-vba

MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts.
http://www.mrexcel.com/forum/forumdisplay.php?f=19
http://www.mrexcel.com/store/index.p...t_detail&p=306

There are over 1800 Excel videos/tutorials here:
http://www.youtube.com/user/ExcelIsFun

Getting Started with VBA.
http://www.datapigtechnologies.com/ExcelMain.htm

If you are serious about learning VBA try
http://www.add-ins.com/vbhelp.htm

Excel Tutorials and Tips - VBA - macros - training
http://www.mrexcel.com/articles.shtml

MrExcel's Excel Tutorial Listing
http://www.mrexcel.com/articles.shtml

[VBA] Difference between OLEFormat and ControlFormat?
For references purposes and excellent explanations, see
http://wellsr.com/vba/excel/#guides

Excel VBA MACRO Kick-start Course for absolute beginner

Free VBA Course
http://www.excel-pratique.com/en/vba.php

Excel 2007 VBA materials to learn here:
http://www.worldbestlearningcenter.c...erstanding.htm

The macro recorder actually is your friend but look here:
http://www.tushar-mehta.com/excel/vb...acro_recorder/

Introduction to Variables, Constants and Data Types
http://msdn.microsoft.com/en-us/libr...(v=vs.60).aspx

Declaring Variables
http://www.cpearson.com/excel/declaringvariables.aspx

Here's a good primer on the scope of variables.
http://www.cpearson.com/excel/scope.aspx
Variable Scope in Excel VBA - EASY Excel Macros
Understanding Scope

Using Variables in Excel VBA Macro Code
http://www.ozgrid.com/VBA/variables.htm

See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

What is a VBA Module and How is a VBA Module Used?
http://www.emagenit.com/VBA%20Folder...vba_module.htm

Events And Event Procedures In VBA
http://www.cpearson.com/excel/Events.aspx

Here is a good introductory tutorial using a VBA Class:
http://www.cpearson.com/excel/classes.aspx

There's a chapter on classes in VBA Developer's Handbook which is also good.
http://www.amazon.com/VBA-Developers.../dp/0782129781

Ron's Excel Tips
http://www.rondebruin.nl/tips.htm

Ron de Bruin's Mail from Excel and make/mail PDF files (Windows)
http://www.rondebruin.nl/win/section1.htm

How do I create and use a PERSONAL file for my VBA code
http://www.rondebruin.nl/win/personal.htm

Anthony's Excel VBA Page - Excel Application - Excel Consultant - Excel Consulting (see 3 tutorials in Excel VBA Basic Tutorial Series)

BET: Microsoft Excel Visual Basic

Debugging VBA
http://www.cpearson.com/Excel/DebuggingVBA.aspx

Debug Excel VBA Macro Code
http://www.ozgrid.com/VBA/debug.htm

TechBookReport - Debugging Excel VBA Code
http://www.techbookreport.com/tutori...el_vba_01.html

Here are some general links on performance improvement:
https://www.soa.org/News-and-Publica...s42-roper.aspx
Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros
Excel VBA Performance Coding Best Practices - Office Blogs
https://msdn.microsoft.com/en-us/library/aa730921.aspx

Start at the beginning...

Creating An XLA Add-In For Excel, Writing User Defined Functions In VBA
http://www.cpearson.com/excel/createaddin.aspx

Build an Excel Add-In
http://www.fontstuff.com/vba/vbatut03.htm

Creating custom functions
http://office.microsoft.com/en-us/ex...117011033.aspx

Writing Your First VBA Function in Excel
http://www.exceltip.com/st/Writing_Y...Excel/631.html

VBA for Excel (Macros)
http://www.excel-vba.com/excel-vba-contents.htm

Excel Macros Tutorial
http://www.excel-vba.com/excel-vba-contents.htm

Excel Macros & Programming
http://www.excel-vba.com/index.htm

VBA Lesson 11: VBA Code General Tips and General Vocabulary
http://www.excel-vba.com/vba-code-2-1-tips.htm

Excel VBA -- Adding Code to a Workbook
http://www.contextures.com/xlvba01.html

Beyond Excel's recorder

Helpful as a simple concise reference for the basics, and, using the macro recorder is endlessly powerful.
http://www.techonthenet.com/excel/cells/index.php

Learn to debug:
http://www.cpearson.com/excel/debug.htm

How To: Assign a Macro to a Button or Shape
http://peltiertech.com/WordPress/how...tton-or-shape/

User Form Creation
http://www.contextures.com/xlUserForm01.html

Build a UserForm for Excel
http://www.fontstuff.com/ebooks/free/fsuserforms.pdf

When To Use a UserForm & What to Use a UserForm For
http://www.ozgrid.com/Excel/free-tra...ba2lesson2.htm

UserForms in Excel VBA - UserForm Basics; Add Controls dynamically at run-time using the Add Method; UserForm Controls (A Snapshot)

VBA add UserForm on the fly
http://www.vbaexpress.com/kb/getarticle.php?kb_id=228

Excel VBA how to Personalise the Ribbon
http://www.bing.com/videos/search?q=...bbon&FORM=VDRE

Excel Tutorials / Video Tutorials - Functions
http://www.contextures.com/xlFunctions02.html

How to insert Buttons, radio buttons and check boxes in Excel
http://www.bing.com/videos/search?q=...xcel&FORM=VDRE

INDEX MATCH - Excel Index Function and Excel Match Function
http://www.contextures.com/xlFunctions03.html

Multi or two way vlook up and index match tutorial
http://www.get-digital-help.com/

Excel Data Validation
http://www.contextures.com/xlDataVal08.html#Larger
http://www.contextures.com/excel-dat...ation-add.html

Excel -- Data Validation -- Create Dependent Lists
http://www.contextures.com/xlDataVal02.html

http://www.get-digital-help.com/2010...lues-in-excel/

Your Quick Reference to Microsoft Excel Solutions
http://www.xl-central.com/index.html

New! Excel Recorded Webinars
http://www.datapigtechnologies.com/ExcelMain.htm

MS Excel: VBA Functions - Listed by Category
MS Excel: ALL Formulas/Functions - Listed by Category

Fuzzy Matching - new version plus explanation
http://www.mrexcel.com/forum/excel-q...planation.html

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.
http://www.cpearson.com/Excel/vbe.aspx

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

John Walkenbach's power programming with Excel books.

Excel 2010 Power Programming with VBA, Mr. Spreadsheet's Bookshelf

by Stephen/ Bovey, Rob/ Green, John Bullen (Paperback - Feb 11, 2005)
Professional Excel Development

by Rob Bovey, Stephen Bullen, John Green, and Robert Rosenberg (Paperback - Sep 26, 2001)
Excel 2002 VBA: Programmers Reference

Professional Excel Development by Rob Bovey, Dennis Wallentin, Stephen Bullen, & John Green

DonkeyOte: My Recommended Reading, Volatility
http://www.decisionmodels.com/calcsecretsi.htm

A list of Reference Books
http://www.andypope.info/books/books.htm

Sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Need to understand error handling
http://www.cpearson.com/excel/errorhandling.htm

Excel file error message
How to diagnose Excel file corruption and repair workbooks

If a file cannot be repaired, consider recovering an earlier version from your file history
https://support.microsoft.com/en-us/...8-file-history

Arrays
http://www.mrexcel.com/forum/showthread.php?t=390246
http://www.cpearson.com/excel/VBAArrays.htm
http://www.xtremevbtalk.com/showthread.php?t=296012
http://www.vbtutor.net/vba/vba_chp21.htm
http://excelmacromastery.com/Blog/in...-in-excel-vba/

**jproffer** · 04-07-2012, 04:56 PM

I've typed this so many times, I'd make it a signature if it wasn't so long, lol...anyhow, here goes.

-Start with the recorder. It's not very efficient, but it does work. Record yourself doing something...anything...or MANY things (but make a list before you start..you'll see why in a minute), then go into the VBE (ALT+F11) and see what it recorded. That's the syntax for every move you made...literally.

-Now start to clean it up.
.....A - If you see anything regarding scrolling...get rid of it.
.....B - If you see something like:

Please Login or Register  to view this content.

that can all be combined to:

Please Login or Register  to view this content.

or even just

Please Login or Register  to view this content.

get it as 'clean' as you can, then run it and see if it does everything on your list.

- Surf the forums as often as you can. Look at what people are asking about, then look at the answers given. Create a workbook that represents the question (as best you can), then use the answer given and see what it does. Try different answers for the same question...two routines that look different from each other can do the exact same thing.

- Get in the habit early on of declaring your variables. You can force this by typing "Option Explicit" at the top of a module, or there is a setting in options in the VBE. Even with the declarations, resist the urge to use Variant for everything

....it will work, but it's not good practice. If you're going to do that, there's no need to declare them at all. Try to type it down as "tight" as you can...for instance, if you're using the variable "i" in a loop and you only want it to loop 10 times ("For i = 1 To 10"), there is no reason to Type "i" as a Long data type, when a Byte data type will be sufficient.

- Coworkers may have projects for you (ask the boss, lol...or don't blame me if you get caught doing, what they might consider, "screwing around"). Family members. Have you ever ran a business? Could some of the paperwork, etc have been automated? Do that...doesn't matter if it's useful to you, or even to anyone...you're learning.

- Learn how to use loops, select case statements, if statements, etc. Even if it doesn't do anything but put numbers down a column(with a loop)...try it...try different ways.

Now that I've said all that, I'll say this:

There are books out there, but I can't personally comment on any of them, because I've never read any of them. I suspect they are full of syntax and examples that are probably not useful in the real world, lol...but I don't know.

**StevenM** · 05-06-2012, 08:41 AM

As a beginner I found the following most helpful:

(1) "VB & VBA in a Nutshell" by Paul Lomax.

(2) "VBA and Macros for Microsoft Office Excel 2007" by Bill Jelen & Tracy Syrstad (it has been updated for Excel 2010)

(3) "Excel 2007 Power Programming with VBA" by John Walkenbach (I believe that it too has been updated for Excel 2010)

(4) "Excel 2007 VBA: Programmer's Reference" by John Green, Stephen Bullen, Rob Bovey, Michael Alexander (I don't know if it has been updated to 2010)

As for:

"Writting Excel Macros with VBA" (2nd edition) by Steven Roman: It is outdated, but I've found it helpful at times. And unfortunately, one mistake in its code took me hours to figure out. It needs to be updated and improved.

"Mastering Microsoft VBA 2nd Edition" by Guy Hart-Davis is another pre-2007 book, but well-written in my opinion.

**nevi** · 05-06-2012, 02:22 PM

I had a project thrown at me for work a few weeks ago which was way above my head, and I have been trying to each myself VBA since. Learned a lot in the last three weeks, and the project is finally almost done!!

What I found the most useful was a step-by-step approach. I picked up Microsoft Excel VBA Programming for Dummies by John Walkenbach and attempted to read it cover to cover. Once it was past the basics, this became more confusing than helpful as I had no relevant referance for the information it was giving. So my approach became this:

1. Attempt to write the code you need and use the debugger to find where it is messing up
2. Looked for specifically what I was trying to do in the book - sometimes it was there, sometimes not
3. Browse these forums and Google the crap out of it. In particular, I try to find code samples doing something simliar to what I am looking for that I can just "tweek" to my needs
4. And when all else failed, I posted the question here and waited patiently for the experts to show me how, or show me where I went wrong

It has been a great learning experience, and I really am quite proud of my (almost) final product. But the biggest thing I learned is that you best friend when you are trying to learn this is to just sit down at your keyboard and screw around. Keep hacking away at it until you have it figured it out - a "Learn By Doing" approach.

Just my two cents worth, but hopefully that is helpful to anyone in my shoes!

**darayuk** · 08-19-2012, 08:44 AM

There are a lot of Excel VBA materials to learn here:http://www.worldbestlearningcenter.c...erstanding.htm

**john456852** · 08-23-2012, 10:08 AM

www.excel-vba.com

**ESF** · 09-05-2012, 02:29 AM

Very useful for me as a beginner was:
http://www.angelfire.com/biz7/julian...ans_macros.htm

**apembo** · 12-07-2012, 05:39 PM

Wow - this demonstrates the absolute value of this forum. Well done all.

I've agree that this page needs to be stickied (what ever that is).

I've found http://www.techonthenet.com/ to be very helpful as a simple concise reference for the basics.
And using the macro recorder is endlessly powerful although you do need to understand the limitations of cutting and pasting from the recorded code.

Some other basic tips:

Always always use "Options Explicit".
When working with multiple work sheets I like to create "WorkSheet" variables to represent worksheets and define them using "set wsControl = Sheets("Control"). You can then better use the autocomplete capabilities of the Macro editor.
When working with data that is ever likely to change in structure, rather than hard coding rows and columns, used named references to define key rows/columns and then use the wsData.Range("<Defined Name>") to get the correct row/column you need. Then if you add a row a column, your code keeps working.
Use comments. Comment and comment some more. Some say there should be more comments than code. Unless you're supremely good at naming variables (the hardest part of coding) then you'll forget how your code works in a couple of months and others will have even less chance.
Learn some basics of the debugger. How to put in a break point. How to add a watch. F8 - step line by line, F5 - run to next breakpoint.

Hope that helps.

**garfield0304** · 01-25-2013, 11:21 AM

I am also fairly new to VBA programming. I recently purchased "VBA and Macros for Microsoft Office Excel 2007" by Bill Jelen & Tracy Syrstad (it has been updated for Excel 2010) and "Excel 2010 Power Programming with VBA" by John Walkenbach. Both are very well written and easy to understand. Good luck and Have fun!!

**xladept** · 02-20-2013, 02:10 PM

I think that "Writing Excel Macros" by Steven Roman and published by O'Reilly has been cited above, but it's the book that I learned from and still refer to when concepts get dicey.

**V-B-A** · 04-05-2013, 12:33 PM

Hello,

I created a VBA course (complete and 100% free) to learn VBA from 0.

11 lessons :

1. Introduction
2. Sheets and cells
3. Variables
4. Conditions
5. Loops
6. Procedures and functions
7. Dialog boxes
8. Events
9. Forms and controls
10. Arrays
11. Supplements

http://www.excel-pratique.com/en/vba.php

Can you add this link to the list?

**kamalg.mmt** · 05-23-2013, 08:58 AM

Another good tutorial to learn basics of vba.
https://www.youtube.com/watch?v=e1NOdjRkLIY

**emjbee** · 07-22-2013, 04:03 PM

Consider "Excel Programming Weekend Crash Course by Peter G. Aitken." It isn't exhaustive, but what is covered is explained very clearly with a minimum of jargon. Good luck!

**OM1950** · 01-11-2014, 04:52 AM

You should also have a look at

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

which is a MS VBA reference library. Most useful.

OM1950

**hanfeng** · 03-18-2014, 10:55 PM

I found some of these links that were helpful to get started. Some of them are from universities:

http://www.chem.mtu.edu/~fmorriso/cm...rial1_2010.pdf

http://www.faculty.virginia.edu/riba.../VBAPrimer.pdf

These other ones have pretty easy to understand tutorials for absolute beginners like me:

http://www.softwaretrainingtutorials...asic-excel.php

http://www.vbaexceltutorial.com/

Hope this helps!

**ExcelQuestFL** · 06-06-2014, 08:13 AM

Just adding 2 resources I've been using that have been helping me a lot.

Udemy - Infinite Skills - Microsoft VBA Excel Tutorial
Excel VBA and Macros 2010 by Bill Jelen

Udemy course is great for beginners, and the Bill Jelen book is more advanced for a beginner. But been learning quite a bit using them together.

Good luck fellow coders

**TRLWNC** · 11-17-2014, 11:39 AM

I recently stumbled across a tutorial channel on YouTube called "Wise Owl Tutorials". I started about 2 weeks ago, and have now built a multi-page program that is functional. He is REALLY good at taking small steps and explaining thoroughly. Here is the link:

https://www.youtube.com/playlist?lis...3akx_gFMnpxTN5

Enjoy!

**stanleydgromjr** · 04-02-2016, 08:30 AM

pulsar777,

See if the following links will help you:

Here is a good introductory tutorial using a VBA Class:
http://www.cpearson.com/excel/classes.aspx

There's a chapter on classes in VBA Developer's Handbook which is also good.
http://www.amazon.com/VBA-Developers.../dp/0782129781

**Trevor76** · 01-17-2017, 06:00 PM

Hi, I would like to suggest Excel Dashboard School for free dashboard training materials.

**sorensjp** · 02-06-2017, 06:37 AM

Hello,

I've learned a lot and used a great many templates from Trevor Easton's site Onlinepclearning and YouTube Channel.
Site:
http://www.onlinepclearning.com/
YouTube Channel:
https://www.youtube.com/user/OnLinePCLearning/featured

He has many templates VBA and Non-VBA projects ready for download and you create and change to suit your needs. Very well laid out and explained for each project in an accompanying YouTube video.

**stanleydgromjr** · 12-31-2017, 05:39 PM

**John_Franco** · 01-29-2018, 07:21 PM

Hi,

If you want to understand the VBA syntax to write your own macros and understand the macros written from others, you should definitely understand the fundamental concept called Excel object model.

Here are some Excel object model articles that might help:

https://msdn.microsoft.com/en-us/vba...-vba-reference
http://www.dummies.com/software/micr...-object-model/
https://www.wizdoh.com/excel-vba-obj...l-demystified/
https://powerspreadsheets.com/excel-vba-object-model/

Thanks

**Jon_P** · 01-31-2018, 12:30 PM

Hello,
I site I used when I started was

Excel Macro Mastery

VBA for Beginners.

Good Luck...

**stanleydgromjr** · 02-03-2018, 09:51 AM

The following update will need to be in the next two replies:

See if something, in the below link(s), of my most up to date list will help you:
Training / Books / Sites as of 2/3/2018

What Is VBA?
https://www.techwalla.com/articles/what-is-vba

MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts.
http://www.mrexcel.com/forum/forumdisplay.php?f=19
http://www.mrexcel.com/store/index.p...t_detail&p=306

There are over 1800 Excel videos/tutorials here:
http://www.youtube.com/user/ExcelIsFun

Getting Started with VBA.
http://www.datapigtechnologies.com/ExcelMain.htm

If you are serious about learning VBA try
http://www.add-ins.com/vbhelp.htm

Excel Tutorials and Tips - VBA - macros - training
http://www.mrexcel.com/articles.shtml

MrExcel's Excel Tutorial Listing
http://www.mrexcel.com/articles.shtml

[VBA] Difference between OLEFormat and ControlFormat?
For references purposes and excellent explanations, see
http://wellsr.com/vba/excel/#guides

Excel VBA MACRO Kick-start Course for absolute beginner

Free VBA Course
http://www.excel-pratique.com/en/vba.php

Excel 2007 VBA materials to learn here:
http://www.worldbestlearningcenter.c...erstanding.htm

The macro recorder actually is your friend but look here:
http://www.tushar-mehta.com/excel/vb...acro_recorder/

Introduction to Variables, Constants and Data Types
http://msdn.microsoft.com/en-us/libr...(v=vs.60).aspx

Declaring Variables
http://www.cpearson.com/excel/declaringvariables.aspx

Here's a good primer on the scope of variables.
http://www.cpearson.com/excel/scope.aspx
Variable Scope in Excel VBA - EASY Excel Macros
Understanding Scope

Using Variables in Excel VBA Macro Code
http://www.ozgrid.com/VBA/variables.htm

See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

What is a VBA Module and How is a VBA Module Used?
http://www.emagenit.com/VBA%20Folder...vba_module.htm

Events And Event Procedures In VBA
http://www.cpearson.com/excel/Events.aspx

Here is a good introductory tutorial using a VBA Class:
http://www.cpearson.com/excel/classes.aspx

There's a chapter on classes in VBA Developer's Handbook which is also good.
http://www.amazon.com/VBA-Developers.../dp/0782129781

Ron's Excel Tips
http://www.rondebruin.nl/tips.htm

Ron de Bruin's Mail from Excel and make/mail PDF files (Windows)
http://www.rondebruin.nl/win/section1.htm

How do I create and use a PERSONAL file for my VBA code
http://www.rondebruin.nl/win/personal.htm

Anthony's Excel VBA Page - Excel Application - Excel Consultant - Excel Consulting (see 3 tutorials in Excel VBA Basic Tutorial Series)

BET: Microsoft Excel Visual Basic

Debugging VBA
http://www.cpearson.com/Excel/DebuggingVBA.aspx

Debug Excel VBA Macro Code
http://www.ozgrid.com/VBA/debug.htm

TechBookReport - Debugging Excel VBA Code
http://www.techbookreport.com/tutori...el_vba_01.html

Here are some general links on performance improvement:
https://www.soa.org/News-and-Publica...s42-roper.aspx
Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros
Excel VBA Performance Coding Best Practices - Office Blogs
https://msdn.microsoft.com/en-us/library/aa730921.aspx

Start at the beginning...

Creating An XLA Add-In For Excel, Writing User Defined Functions In VBA
http://www.cpearson.com/excel/createaddin.aspx

Build an Excel Add-In
http://www.fontstuff.com/vba/vbatut03.htm

Creating custom functions
http://office.microsoft.com/en-us/ex...117011033.aspx

Writing Your First VBA Function in Excel
http://www.exceltip.com/st/Writing_Y...Excel/631.html

VBA for Excel (Macros)
http://www.excel-vba.com/excel-vba-contents.htm

Excel Macros Tutorial
http://www.excel-vba.com/excel-vba-contents.htm

Excel Macros & Programming
http://www.excel-vba.com/index.htm

VBA Lesson 11: VBA Code General Tips and General Vocabulary
http://www.excel-vba.com/vba-code-2-1-tips.htm

Excel VBA -- Adding Code to a Workbook
http://www.contextures.com/xlvba01.html

Beyond Excel's recorder

Helpful as a simple concise reference for the basics, and, using the macro recorder is endlessly powerful.
http://www.techonthenet.com/excel/cells/index.php

Learn to debug:
http://www.cpearson.com/excel/debug.htm

How To: Assign a Macro to a Button or Shape
http://peltiertech.com/WordPress/how...tton-or-shape/

User Form Creation
http://www.contextures.com/xlUserForm01.html

Build a UserForm for Excel
http://www.fontstuff.com/ebooks/free/fsuserforms.pdf

When To Use a UserForm & What to Use a UserForm For
http://www.ozgrid.com/Excel/free-tra...ba2lesson2.htm

UserForms in Excel VBA - UserForm Basics; Add Controls dynamically at run-time using the Add Method; UserForm Controls (A Snapshot)

VBA add UserForm on the fly
http://www.vbaexpress.com/kb/getarticle.php?kb_id=228

Excel VBA how to Personalise the Ribbon
http://www.bing.com/videos/search?q=...bbon&FORM=VDRE

Excel Tutorials / Video Tutorials - Functions
http://www.contextures.com/xlFunctions02.html

How to insert Buttons, radio buttons and check boxes in Excel
http://www.bing.com/videos/search?q=...xcel&FORM=VDRE

INDEX MATCH - Excel Index Function and Excel Match Function
http://www.contextures.com/xlFunctions03.html

Multi or two way vlook up and index match tutorial
http://www.get-digital-help.com/

Excel Data Validation
http://www.contextures.com/xlDataVal08.html#Larger
http://www.contextures.com/excel-dat...ation-add.html

Excel -- Data Validation -- Create Dependent Lists
http://www.contextures.com/xlDataVal02.html

http://www.get-digital-help.com/2010...lues-in-excel/

Your Quick Reference to Microsoft Excel Solutions
http://www.xl-central.com/index.html

New! Excel Recorded Webinars
http://www.datapigtechnologies.com/ExcelMain.htm

MS Excel: VBA Functions - Listed by Category
MS Excel: ALL Formulas/Functions - Listed by Category

Fuzzy Matching - new version plus explanation
http://www.mrexcel.com/forum/excel-q...planation.html

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.
http://www.cpearson.com/Excel/vbe.aspx

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

John Walkenbach's power programming with Excel books.

Excel 2010 Power Programming with VBA, Mr. Spreadsheet's Bookshelf

by Stephen/ Bovey, Rob/ Green, John Bullen (Paperback - Feb 11, 2005)
Professional Excel Development

by Rob Bovey, Stephen Bullen, John Green, and Robert Rosenberg (Paperback - Sep 26, 2001)
Excel 2002 VBA: Programmers Reference

Professional Excel Development by Rob Bovey, Dennis Wallentin, Stephen Bullen, & John Green

DonkeyOte: My Recommended Reading, Volatility
http://www.decisionmodels.com/calcsecretsi.htm

A list of Reference Books
http://www.andypope.info/books/books.htm

Sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Need to understand error handling
http://www.cpearson.com/excel/errorhandling.htm

Excel file error message
How to diagnose Excel file corruption and repair workbooks

If a file cannot be repaired, consider recovering an earlier version from your file history
https://support.microsoft.com/en-us/...8-file-history

Arrays
http://www.mrexcel.com/forum/showthread.php?t=390246
http://www.cpearson.com/excel/VBAArrays.htm
http://www.xtremevbtalk.com/showthread.php?t=296012
http://www.vbtutor.net/vba/vba_chp21.htm
http://excelmacromastery.com/Blog/in...-in-excel-vba/

**stanleydgromjr** · 02-03-2018, 09:52 AM

**AliGW** · 08-10-2018, 04:07 AM

PLEASE NOTE:

This thread is a sticky as it has become a compendium of useful links and resources for members to use to learn VBA.

You may post to this thread ONLY if you have a new resource to add to the list (this must NOT include advertising links - see our forum's rules).

If you wish to thank anyone who has contributed to this thread, please do so using the reputation system by clicking on the star to the bottom left of one of their posts and leaving a 'thank you' message. Any 'thank yous' or other 'noise' posted to this thread should be reported and will be deleted. This is so that the thread remains clean and easy to navigate for all.

Thank you all for your co-operation.

**Novice64** · 03-01-2020, 09:16 PM

A search on Youtube for "Excel Leila Gharani" will turn up videos on all Excel topics, including VBA from the basics to reasonably advanced.

I've found her training style to be easy to follow and effective.

**MrProcessCPC** · 07-15-2020, 07:45 AM

Just did the VBA Handbook course from Excel Macro Mastery
Has some great articles on his site and many YouTube videos. Does a webinar every few months. Awesome at explaining great coding techniques.

**6StringJazzer** · 08-29-2024, 08:52 PM

joeTr, your post is not relevant to this thread and does not ask a question. If you have a question, please take the time to review our rules, and start a new thread using code tags for your code. PM me if you have further questions.

New to Excel Programming and looking for learning materials

LinkBack

Thread Tools

Rate This Thread

Display

New to Excel Programming and looking for learning materials

re: New to Excel Programming and looking for learning materials

re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Re: New to Excel Programming and looking for learning materials

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions