Skip to main content

Complete list of all VBA statements

VBA statements are keywords defined in the Visual Basic for Applications specification that make up the VBA language. Statements are used to control program flow, manipulate data, handle errors, communicate with the file system, and act as labels. In contrast, functions primarily return a value or values.

Statement Action
AppActivate Activates an application window
Beep Sounds a tone through the computer's speaker
Call Transfers control to another procedure
ChDir Changes the current directory
ChDrive Changes the current drive
Close Closes a text file
Const Declares a constant value
Date Sets the current system date
Declare Declares a reference to an external procedure in a Dynamic Link Library (DLL)
DefBool Sets the default data type to Boolean for variables that begin with specified letters
DefByte Sets the default data type to Byte for variables that begin with specified letters
DefCur Sets the default data type to Currency for variables that begin with specified letters
DefDate Sets the default data type to Date for variables that begin with specified letters
DefDec Sets the default data type to Decimal for variables that begin with specified letters
DefDbl Sets the default data type to Double for variables that begin with specified letters
DefInt Sets the default data type to Integer for variables that begin with specified letters
DefLng Sets the default data type to Long for variables that begin with specified letters
DefLngLng Sets the default data type to LongLong for variables that begin with specified letters
DefLngPtr Sets the default data type to LongPtr for variables that begin with specified letters
DefObj Sets the default data type to Object for variables that begin with specified letters
DefSng Sets the default data type to Single for variables that begin with specified letters
DefStr Sets the default data type to String for variables that begin with specified letters
DefVar Sets the default data type to Variant for variables that begin with specified letters
DeleteSetting Deletes a section or key setting from an application's entry in the Windows Registry
Dim Declares variables and (optionally) their data types
Do...Loop Loops through a set of instructions
End Used by itself, exits the program; also used to end a block of statements that begin with If, With, Sub, Function, Property, Type, or Select
Enum Declares a type for enumeration
Erase Reinitializes an array
Error Simulates a specific error condition
Event Declares a user-defined event
Exit Do Exits a block of Do-Loop code
Exit For Exits a block of For-Next code
Exit Function Exits a Function procedure
Exit Property Exits a property procedure
Exit Sub Exits a subroutine procedure
FileCopy Copies a file
For Each...Next Loops through a set of instructions for each member of a series
For...Next Loops through a set of instructions a specific number of times
Function Declares the name and arguments for a Function procedure
Get Reads data from a text file
GoSub...Return Branches to and returns from a procedure
GoTo Branches to a specified statement within a procedure
If...Then...Else Processes statements conditionally
Implements Specifies an interface or class that will be implemented in a class module
Input # Reads data from a sequential text file
Kill Deletes a file from a disk
Let Assigns the value of an expression to a variable or property
Line Input # Reads a line of data from a sequential text file
Load Loads an object but doesn't show it
Lock, Unlocks Controls access to a text file
LSet Left-aligns a string within a string variable
Mid Replaces characters in a string with other characters
MkDir Creates a new directory
Name Renames a file or directory
On Error Gives specific instructions for what to do in the case of an error
On...GoSubs Branches, based on a condition
On...GoTos Branches, based on a condition
Open Opens a text file
Option Base Sets the default lower limit for arrays
Option Compare Declares the default comparison mode when comparing strings
Option Explicit Forces declaration of all variables in a module
Option Private Indicates that an entire module is Private
Print # Writes data to a sequential file
Private Declares a local variable
Property Get Declares the name and arguments of a Property Get procedure
Property Let Declares the name and arguments of a Property Let procedure
Property Set Declares the name and arguments of a Property Set procedure
Public Declares a public variable
Put Writes a variable to a text file
RaiseEvent Fires a user-defined event
Randomize Initializes the random number generator
ReDim Changes the dimensions of an array
Rem Specifies a line of comments (same as an apostrophe ['])
Reset Closes all open text files
Resume Resumes execution when an error-handling routine finishes
RmDir Removes an empty directory
RSet Right-aligns a string within a string variable
SaveSetting Saves or creates an application entry in the Windows Registry
Seek Sets the position for the next access in a text file
Select Case Processes statements conditionally
SendKeys Sends keystrokes to the active window
Set Assigns an object reference to a variable or property
SetAttr Changes attribute information for a file
Static Declares variables at the procedure level so that the variables retain their values as long as the code is running
Stop Pauses the program
Sub Declares the name and arguments of a Sub procedure
Time Sets the system time
Type Defines a custom data type
Unload Removes an object from memory
While...Wend Loops through a set of instructions as long as a certain condition remains true
Width # Sets the output line width of a text file
With Sets a series of properties for an object
Write # Writes data to a sequential text file

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>