Excel VBA Cheat Sheet - Ultimate VBA Reference and Code Snippets. VBA Cheat Sheet. VBA syntax, variables, loops, conditions, Classes, Types, Enumerations etc. The best VBA cheat sheet out there! Article by Bill Edwards. Excel Macros Microsoft Excel Cheat Sheets. DataMember, DataSource, DragIcon, DragMode, Enabled, Font, FontBold, FontItalic, FontStrikethru, FontUnderline, FontName, FontSize, Height, Width, HelpContextID, Index.
-->The syntax in a Visual Basic Help topic for a method, function, or statement shows all the elements necessary to use the method, function, or statement correctly. The examples in this topic explain how to interpret the most common syntax elements.
Activate method syntax
object.Activate
In the Activate method syntax, the italic word 'object' is a placeholder for information you supply—in this case, code that returns an object. Words that are bold should be typed exactly as they appear. For example, the following procedure activates the second window in the active document.
MsgBox function syntax
Vba Syntax Guide
MsgBox (prompt, [ buttons, ] [ title, ] [ helpfile, context ])
In the MsgBox function syntax, the italic words are named arguments of the function. Arguments enclosed in brackets are optional. (Do not type the brackets in your Visual Basic code.) For the MsgBox function, the only argument you must provide is the text for the prompt.
Arguments for functions and methods can be specified in code either by position or by name. To specify arguments by position, follow the order presented in the syntax, separating each argument with a comma, for example:
To specify an argument by name, use the argument name followed by a colon and an equal sign (:=), and the argument's value. You can specify named arguments in any order, for example:
The syntax for functions and some methods shows the arguments enclosed in parentheses. These functions and methods return values, so you must enclose the arguments in parentheses to assign the value to a variable. If you ignore the return value or if you don't pass arguments at all, don't include the parentheses. Methods that don't return values do not need their arguments enclosed in parentheses. These guidelines apply whether you are using positional arguments or named arguments.
In the following example, the return value from the MsgBox function is a number indicating the selected button that is stored in the variable myVar
. Because the return value is used, parentheses are required. Another message box then displays the value of the variable.
Option Compare statement syntax
Option Compare { Binary | Text | Database }
In the Option Compare statement syntax, the braces and vertical bar indicate a mandatory choice between three items. (Do not type the braces in the Visual Basic statement). For example, the following statement specifies that within the module, strings will be compared in a sort order that is not case-sensitive.
Dim statement syntax
Dimvarname [([ subscripts ])] [ Astype, ] [ varname [([ subscripts ])] [ Astype ]] . . .
In the Dim statement syntax, the word Dim is a required keyword. The only required element is varname (the variable name).
For example, the following statement creates three variables: myVar
, nextVar
, and thirdVar
. These are automatically declared as Variant variables.

The following example declares a variable as a String. Including a data type saves memory and can help you find errors in your code.
To declare several variables in one statement, include the data type for each variable. Variables declared without a data type are automatically declared as Variant.
Access Vba Code Cheat Sheet
In the following statement, x
and y
are assigned the Variant data type. Only z
is assigned the Integer data type.
Vba Syntax Cheat Sheet Pdf
The shorthand to declare x
and y
as Integer in the statement above is:
The shorthand for the types is: % -integer; & -long; @ -currency; # -double; ! -single; $ -string
If you are declaring an array variable, you must include parentheses. The subscripts are optional. The following statement dimensions a dynamic array, myArray
.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Welcome to my end-to-end VBA Cheat Sheet. Be sure to bookmark this page as your Excel VBA cheat sheet!. Visual Basic for Applications makes automation possible in Excel and other Office applications. The below Excel VBA Cheatsheet is your one stop shop for a variety of useful VBA automations. If you are new to VBA start with my Excel VBA Tutorial.
VBA BASICS
Basic VBA syntax, loops, variables, arrays, classes and more
VBA FUNCTIONS
Date, File, String and more functions
WORKING WITH FILES
Working with files (Excel, text, CSV, XML etc.). Learn how to read, write, edit, download files in VBA etc.
EXCEL VBA
Excel VBA – working with Worksheets, Workbooks, Cells, Ranges, formatting etc.
DATA ANALYSIS EXCEL TOOLS
…because sometimes you just don’t need to resort to VBA
WORD VBA
Word VBA – navigating around Word documents, formatting etc.
POWERPOINT VBA
This VBA Cheat Sheet is updated on a regular basis with the best new posts on VBA.
VBA TIME SAVER

Tired of having to constantly Google common VBA code snippets? Get the VBA Time Saver. Consisting of at least 7 Code Modules it is probably the largest colletion of VBA Code Snippets on the Web! Find code to manage VBA Arrays, Files, Strings, Regular Expressions, Performance Enhancement, VBA Structures and even an animated Progress Bar, all with ready examples to save you time.
