You are browsing Vertex42's directory of Excel websites and resources. Browse Vertex42's Excel Templates

Creating Macros in Excel can lead to an amazing increase in productivity. This list of resources for VBA and Excel Macros is definitely not comprehensive, but it can help get you started.

Skip ahead to ...


1Chip Pearson's Excel Topicswww.cpearson.com
An extensive list of topic-specific Excel and VBA tutorials and examples.
Added: 05-22-2004 - Updated: 09-10-2019
2David McRitchie's Excel Pageshttp://dmcritchie.mvps.org/excel/excel.htm
Excel macros and usage notes to help beginners and fairly advanced users work with Excel spreadsheets. Worksheet Formulas, VBA Macros, Backup, Building a TOC, Color, Event Macros, Excel Newsgroups, HTML, List of Functions and Subroutines, Shortcuts.
Added: 04-02-2004 - Updated: 09-10-2019
3Excel VBA Codehttp://www.ozgrid.com
Browse OzGrid.com for Excel VBA code examples. The site does have a lot of free Excel VBA code and macro tips, although you may need to wade through some advertising.
Added: 04-03-2004 - Updated: 09-10-2019
Free Online Video Tutorials and Example Macros (VBA code) - updated weekly. There is also a Forum and a section of Helpful Excel Tips.
Added: 09-15-2008 - Updated: 09-10-2019

Excel VBA Tutorials

Tutorials for learning VBA for Excel and techniques for creating macros, add-ins, and custom functions.

5Learn Excel VBA Easilyexcel-vba-easy.com
Excel VBA Easy explains the basics and more of Excel VBA. Write your own macros in Excel VBA quickly and easily. Learn more about programming techniques, Ranges, Events, Arrays, Dates, Controls, Userforms and many more Excel VBA topics.
Added: 07-07-2010 - Updated: 09-10-2019
This blog focuses on teaching VBA in Excel via online tutorials.
Added: 03-22-2016 - Updated: 09-10-2019
7Power SpreadsheetsPowerSpreadsheets.com
Detailed and thorough tutorials about Excel and VBA, by Jorge A Gomez.
Added: 08-02-2016 - Updated: 09-10-2019
8Learn Excel VBA Easilyexcel-vba-easy.com
Excel VBA Easy explains the basics and more of Excel VBA. Write your own macros in Excel VBA quickly and easily. Learn more about programming techniques, Ranges, Events, Arrays, Dates, Controls, Userforms and many more Excel VBA topics.
Added: 07-07-2010 - Updated: 09-10-2019

Specific VBA Stuff

Convert RGB values into HLS values and vice versa. Very useful for manipulating the color palette in Excel.
Added: 09-28-2004 - Updated: 09-10-2019