Designed to help you overcome the "growing pains" commonly encountered when learning a new programming language.

This Cheat Sheet is called The Fundamentals of VBA for a reason: If you don't master the skills taught in this Cheat Sheet, you're unlikely to become a good VBA Developer.

With this Cheat Sheet, you won't have to memorize any complicated syntax. The Cheat Sheet will show you the syntax with a bunch of examples.

This Cheat Sheet is packed with:

• 30+ useful VBA tips covering 25 fundamental VBA topics.
• 20+ comprehensive macro examples for you to reference as you start developing your own Subroutines.

Among others, this Cheat Sheet:

• Teaches you:
  • The most common VBA data types (for ex., String, Double, Integer, Variant); and
  • How to declare data types.
• Gives you 13 examples on how to control your spreadsheet with macros.

With the Logic and Loops Cheat Sheet, complex conditional statements and nested loops will be a breeze.

This Cheat Sheet is your one-stop cheat sheet for learning everything you need to know to get started:

• Using conditional logic; and
• Iterating with loops.

This Cheat Sheet dives deep into several essential VBA logic and loop topics, including the following:

• If... Then... Else.
• For... Next.
• Do... While.

In fact, each of the 5 VBA loop structures is fully explained with:

• Helpful examples; and
• Syntax highlighting.

This Cheat Sheet is packed with:

• 30 useful VBA tips covering 12+ VBA logic and loop topics.
• 15+ comprehensive macro examples demonstrating how to use loops and conditional statements to enhance your macros.

Many VBA Developers think they know a lot about arrays. In reality, they've (only) just scratched the surface of what arrays can do. For example, they may not know how to:

• Remove duplicates from an array using a scripting dictionary; or
• Return an array's dimensions.

For example, do you know how to:

• Sort arrays?
• Filter arrays?
• Find an item's position inside an array?

Arrays can be a complicated topic. When you start manipulating arrays, it can be hard to remember (exactly) how to do it.

This Cheat Sheet was developed to address the challenges above.

This Cheat Sheet is packed with 20+ pre-built macros and snippets you're likely to use often when working with arrays. 

Easily copy and paste the macro examples you need to:

• Sort arrays.
• Filter arrays.
• Remove duplicates from arrays.
• Much more.

In addition to advanced topics, this Cheat Sheet (also) contains refreshers for basic concepts, like the following:

• Declare arrays.
• Resize arrays.

The most comprehensive Cheat Sheet devoted to VBA strings.

This Cheat Sheet is packed with tips describing everything you could possibly want to know about working with, and controlling, strings in VBA.

• Describes every string manipulation function.
• Includes RegEx pattern recognition tips.
• Contains custom ready-to-go User Defined Functions to give you even more control over strings.
• Describes how to:
  • Parse;
  • Convert;
  • Compare;
  • Search; and
  • Replace a substring in a string.

Filled with everything you need to know about VBA File I/O. This Cheat Sheet looks at the following topics:

• Reading and writing files using the VBA Open Statement.
• Working with files and folders using the FileSystemObject.
• Customizing user interactions with Application.FileDialog boxes.

After you download the File I/O Cheat Sheet, you'll know how to:

• Extract data from the following files:
  • Text.
  • CSV.
  • Binary.
• Quickly jump to a particular line in your file.
• Append new data to an existing file.

This Cheat Sheet is packed with:

• 50 tips for working with files.
• 30+ comprehensive file input/output macro examples.

Working with files in Excel is essential for quick data analysis. Automatically controlling files using VBA:

• Speeds up tedious data import; and
• Reduces the likelihood of human error.

The next time you need to manipulate files, copy and paste the fully functional macro examples directly from this Cheat Sheet.

This guide to designing and controlling VBA UserForms is a must-have when building custom forms in Excel.

• Describes all 16 UserForm controls; and
• Explains which properties you need to modify to make those UserForm controls look sharp.

From adding items to a ListBox, to incrementing values with a SpinButton.

This Cheat Sheet is:

• Packed with macro examples for controlling different UserForm elements.
• Designed to reduce the amount of time you need to create beautiful and functional forms.