The VBA Reference Card — Cheat Sheet for Beginners

The most important VBA commands on 2 A4 pages. Print it and hang it by your screen when you code.

Contents

  • Basic syntax (Sub, Function, End)
  • Variables and data types (String, Integer, Boolean…)
  • Range and Cells (cell references)
  • Loops (For…Next, Do…While)
  • If…Then…Else (conditions)
  • Common methods (.Value, .Formula, .Copy, .Delete)
  • Common objects (Workbook, Worksheet, Range)
  • Debugging techniques
  • Keyboard shortcuts in the VBA editor

Download the VBA reference card for free

Enter your e-mail and we will send you the PDF straight away.

Created by Lukas Lilja, VBA consultant since 2010.