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!
Record your mouse clicks and cursor movements and convert them directly into VBA macros so you can automate your mouse!
Build stunning dashboards by dynamically controlling your shapes with this add-in that enables conditional formatting for shapes!
Microsoft certified instructor, Kyle Pew, teaches you how to leverage the most powerful automation tool in Microsoft Excel. This course is so popular that enrollment is only open periodically. Check for availability now!
Learn the nuts and bolts of Excel VBA with this online course from Excel MVP, Sumit Bansal over at Trump Excel. This self-paced course is full of practical macro examples. Availability may be limited.
Taught by my good friend John at MyExcelOnline, this is the most comprehensive Excel pivot table course around. Don't let the price tag deter you. This course is well worth every penny. Availability may be limited.
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+.
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.
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.
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: wellsr.com 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 Amazon.com and affiliated sites. Your purchase helps support the work I do to help people around the world learn VBA.
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 wellsr.com where he seeks to inspire office workers to automate their work using his VBA tutorials and code examples.