The Excel VBA Store

I see people struggling with Excel every day and I want to help.

That's why I developed these resources to help you write better macros in half the time.

VBA Training

Ultimate VBA Training Bundle

$80 $52

We've combined each of our comprehensive reference guides into a single bundle with over 150 tips and macros covering the 80 most important topics in VBA.

The MyExcelOnline Academy


Leverage a vibrant Excel community & structured learning environment to enhance your Excel level within 30 Days with this proven professional learning program.

File Input/Output


This 3-page reference guide includes everything you need to know about File I/O, including multiple ways to read from files, write to files, append to files, and prepend to files.

Handling Arrays


This cheat sheet is full of premium tips and tricks for working with arrays. It features over 20 macro examples and is setup in a beautiful 2-page reference guide.

Logic and Loops


Dive deep into IF THEN, FOR NEXT, DO WHILE and many more logic and loop topics with this cheat sheet featuring 30 VBA tips and over a dozen macro examples.



This cheat sheet includes over 30 useful VBA tips covering the 25 most important topics in VBA. It also crams in over 20 helpful VBA macros!

Excel Add-ins, Software and Games

Mouse to Macro


Use Excel to record your mouse clicks and cursor movements and convert them directly into VBA macros so you can automate your mouse.



Automatically import hundreds of VBA macros directly into your spreadsheet and organize your own macro library with my best-selling add-in.

CF Shapes


Build stunning dashboards by dynamically controlling your shapes with this add-in that enables conditional formatting for shapes!



The default methods to password protect your macros can easily be hacked. Protect your intellectual VBA property from hackers and prying eyes like I do with Unviewable+.



Export all kinds of Excel objects to PDFs. Choose what you want to save and how you want to save them!

Hot Key Excellence

$159 Free trial available

If you're serious about learning Excel shortcuts, formulas and macros, you NEED to check out this fun game. That's right. This product makes learning Excel into a game! Don't believe me? Check out the free trial.

VBA Books

VBA and Macros: Microsoft Excel 2010

Check Latest Price

Written by Mr. Excel himself, Bill Jelen, this is without a doubt the best book for learning VBA. This book covers everything you could possibly want to know about Excel macros in a comprehensive, yet understandable, way.

Excel Macro Mastery

Check Latest Price

Written by Paul Kelly, this book is great for beginners wanting to dip their feet in the VBA waters. Paul starts with some ice breaker questions before jumping into the three magic elements of VBA.

Mastering VBA for Microsoft Office 2016

Check Latest Price

Fully updated to cover all the latest VBA tools and tricks in Excel 2016, Richard does a good job explaining the terminology to avoid scaring readers off with programming lingo.

Affiliate Disclaimer: and the Excel VBA Store may contain affiliate endorsements, advertisements and links, which means that if you click on a link and buy something, I may receive a percentage of the sale, at no extra cost to you. I only write about and promote products I believe in. I'm not going tell you about stuff that's dumb. We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to and affiliated sites. Your purchase helps support the work I do to help people around the world learn VBA.

Ryan Wells

Ryan Wells is a Nuclear Engineer in Charlotte, North Carolina. Since graduating from the University of Florida in 2012 with a Bachelor of Science in Nuclear Engineering and a 4.0 GPA, he has been employed in Duke Energy's BWR Fuel Engineering department where he supports the Brunswick Nuclear Plant. In college, Ryan was the captain of the Chipola College Brain Bowl team in Marianna, Florida. His team won the 2009 Florida State Championship and went on to finish second at the national NAQT Community College Championship Tournament (CCCT). Ryan is the founder of where he seeks to inspire office workers to automate their work using his VBA tutorials and code examples.