You are browsing Vertex42's directory of Excel websites and resources. Browse Vertex42's Excel Templates
Excel VBA
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 ...
An extensive list of topic-specific Excel and VBA tutorials and examples.
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.
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.
Free Online Video Tutorials and Example Macros (VBA code) - updated weekly. There is also a Forum and a section of Helpful Excel Tips.
Excel VBA Tutorials
Tutorials for learning VBA for Excel and techniques for creating macros, add-ins, and custom functions.
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.
This blog focuses on teaching VBA in Excel via online tutorials.
Detailed and thorough tutorials about Excel and VBA, by Jorge A Gomez.
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.
Specific VBA Stuff
Convert RGB values into HLS values and vice versa. Very useful for manipulating the color palette in Excel.
