That's why I developed these resources to help you write better macros in half the time.
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.
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.
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.
By describing every string manipulation function and including RegEx pattern recognition tips, this is easily the most comprehensive reference guide devoted to VBA strings around.
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.
If you plan on building VBA applications, you need to follow the methods in this training course. The Excel VBA Handbook is the only available course that teaches you how to build VBA applications from scratch.
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.
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 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.
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.
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.