VBA Training Bundle
$120 $60
I know how hard it is to learn a new programming language. There's so much to remember, the syntax is confusing, and it takes too long to get your code to work right. To help, we made six PDF reference guides with over 200 tips and macros covering the 125 most important topics in VBA. Save 50% when you bundle these 6 wellsrPRO VBA training guides.
Get the bundleAll our VBA cheat sheets are delivered in PDF format and are available for immediate download.
VBA UserForms
$20
This guide to designing and controlling VBA UserForms is a must-have when building custom forms in Excel. Our VBA UserForms Cheat Sheet describes all 16 UserForm controls and explains which properties you need to modify to get them looking sharp. Complete with macro snippets for dynamically populating controls, this cheat sheet is a one-stop-shop for designing and controlling VBA UserForms.
File Input/Output
$20
Split into three parts, this three page Reference Guide takes an in-depth look at the VBA Open Statement, the FileSystemObject, and Application.FileDialog boxes. It 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
$20
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 printable reference guide designed to help you declare, populate, sort, and filter your arrays.
Using Strings
$20
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. It even describes how to parse, convert, compare, search, and replace a substring in a string.
Logic and Loops
$20
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. With this cheat sheet, complex conditional statements and nested loops will be a breeze.
VBA Fundamentals
$20
Great for beginners, 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!
