200+ tips and macros covering the 125 most important VBA topics

These 6 Cheat Sheets are filled with everything you need to know to become an Excel VBA expert. 

The Cheat Sheets were made with you in mind.

Each page of these multi-column Cheat Sheets is packed with information designed to make you a better VBA developer

6 comprehensive reference guides combined into a single VBA training bundle

Fundamentals of VBA

Logic and Loops



File I/O


"Cheat" your way

from beginner-level Developer

to advanced Programmer

  • You'll never forget how to extract data from the following files:
    • Text.
    • CSV.
    • Binary.
  • Figuring out how to remove duplicates from an array will be a thing of the past.
  • Instantly know the proper syntax for controlling each of the 5 VBA loops.
  • You'll see special macro tips that teach you how to do (among others) the following:
    • Efficiently control your spreadsheet.
    • Read a file line by line.
    • Sort your arrays (from smallest to largest).
    • Dynamically add items to a UserForm ListBox.
  • The next time you're working on an Application, simply:
    • Apply the tricks in the Cheat Sheets; and
    • Copy and paste fully functional macro examples directly from the Cheat Sheets.

Something about having all these cheat sheets printed out on my desk makes me feel like a real developer. When I need a reminder for how to declare module or project level variables, I just flip over to my "fundamentals" cheat sheet and get a quick refresher. They're pretty inspiring!

Jacob N.

The Ultimate VBA Cheat Sheet Bundle

Save over 50% when you purchase the entire VBA Cheat Sheet Bundle. Get the following comprehensive Cheat Sheets:

  • The Fundamentals of VBA (Beginner).
  • VBA Logic and Loops (Beginner).
  • Handling VBA Arrays (Intermediate).
  • Using Strings in VBA (Intermediate).
  • VBA File Input/Output (Advanced).
  • VBA UserForms (Advanced).
Overcome the "growing pains" commonly encountered when learning a new programming language

Learn More...

Get started using conditional logic and iterating with loops in VBA

Learn More...

Basic and advanced concepts and strategies to manipulate arrays

Learn More...

The most comprehensive Cheat Sheet devoted to VBA strings

Learn More...

Everything you need to know about VBA file I/O

Learn More...

A must have when building custom forms in Excel

Learn More...

Get all 6 Cheat Sheets NOW for one LOW price!

Note: Prices above are in USD and do not include taxes (if applicable).


Here are answers to some frequently asked questions:

How do I access my Cheat Sheet(s) after purchase?

Are these Cheat Sheets for Mac or Windows?

What payment methods are accepted? 

How is my credit card payment processed?

Are refunds available for Cheat Sheets?

Copyright © 2015–2024 PDS Intelligence Pte. Ltd. All rights reserved

Privacy Policy | Terms and Conditions | Limit of Liability and Disclaimer of Warranty | Affiliate Disclosure