Recommended VBA resources

< Back to home

< Back to development tips

DIY  vs  VBA Courses

You can learn almost everything with free online material however you may not learn the most effective way to do things and risk code running slow and getting errors.  Below are a list of recommended free VBA resources and courses. 


  • Record macros > check code.  I have learnt so much over the years by recording a macro and then viewing the code.  This method is a very quick way to learn, particularly with formatting cells and shapes.
  • Google search "VBA + outcome you want".  Extensive blogs and code is available free online.  This is a great way to solve a specific query.
  • Press F2 in VBA to scan through objects and functions available.
  • You must become familiar with how to debug in VBA.  Something that many people do not realise is you can drag the yellow arrow in debug mode with your mouse to skip executing code.

Great free resources If you want to create stunning excel dashboards read this tutorial. If you want to create stunning excel dashboards you must read this tutorial.  Great free Excel templates Great information for new Excel users.


Excel and VBA resources

 Click free excel add-ins here.

Website Name

Description Useful Excel addins Excel training servcies
Advanced Excel and VBA Excel and VBA tips facebook page Excel data analysis software The “Excel-to-Word Document Automation Add-in” updates Word & PowerPoint content (text, tables, and charts) based on data and calculations in Excel. The add-in uses durable links that don’t break and eliminates repeated copy/paste from Excel. Excel tips addins and tricks Excel tips and tricks Excel examples and tips

Better solutions:  

Very comprehensive list VBA terms with usage guidelines for each

Spreadsheet flowchart addin tool

Excel tip, trick and examples

VBA programming tools.

Excel training and tips. 
Computers tutsplus Guidelines to using Excel styles  Excel tips, tutorials and support. Excel tutorials Excel tips and add-ins
Gcfglobal Free Excel 2016 tutorials
Excel campus General Excel courses and useful articles. Excel automation for developing spreadsheets Excel tips and guides. Excel tips for Lawyers
Excel for free lancers Excel facebook group for freelancers

Excel Jet

General Excel courses and useful articles. Clear, concise, and complete VBA training.  Technical writing and instructions are of the highest standard so anyone can rapidly learn VBA.  Material is very well arranged and comprehensive.
Excel ribbon tips Excel tricks and tips
Excel Solutions (Facebook group) Excel tricks and tips
ExcelTricks (Facebook group) for Excel tips and tricks
Guru 99 - Excel Excel tutorials

Guru 99 - VBA

VBA tutorials Excel training
Icaew (blog) Developing spreadsheets effectively as a team
Learn Excel Group (Facebook group) Excel VBA tips
Learn Microsoft Excel (Facebook group) Excel discussion group
Ron De Bruin  Very specific advanced VBA guidelines, particularly around developing ribbons.  Thanks to some of his publicly available information it helped me develop this software.  Free code samples provided, very clever guy.
Smart sheet Useful Excel templates
Made in Excel (Facebook group) Excel discussion group
Microsoft guide Free guide to using Excel Effectively
My excel online Learn Excel from 500+ free step by step tutorials, podcast shows, webinars and online courses!
PC Mag (blog) Tips for creating professional looking spreadsheets
Small business Excel tips for small businesses
Tech republic (blog) Tips for creating professional looking spreadsheets
The balancesmb How to create accounting spreadsheets
Tomsguide Useful Excel shortcuts
Trump Excel General Excel courses and useful articles.
Vertex42 Useful Excel templates



< Back to home

< Back to development tips