The Excel VBA Store

I see people struggling with Excel every day and I want to help.

That's why I developed these cheat sheets to help you write better macros in half the time.

Shop Categories

VBA Training

Ultimate VBA Training Bundle

$100 $52

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.

File Input/Output

$20

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.

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 reference guide.

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.

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.

Fundamentals

$20

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!

Other VBA Tools

Mouse to Macro

$15

Use Excel to record your mouse clicks and cursor movements and convert them directly into VBA macros so you can automate your mouse.