| AppActivate title , wait | Activates the running application with the title or task ID given by title . |
| Beep | Beeps the speaker. |
| Call name, argumentlist | Calls the name procedure. (Because you can call a procedure just by using its name, the Call statement is rarely used in VBA programming.) |
| ChDir path | Changes the current directory (folder) to path . |
| ChDrive drive | Changes the current drive to drive . |
| Close filenumberlist | Closes one or more I/O files opened with the Open statement. |
| Const CONSTNAME | Declares a constant variable named CONSTNAME . |
| Date = date | Changes the system date to date . |
| Declare name | Declares a procedure from a dynamic link library (DLL). |
| DefBool letterrange | A module-level statement that sets the default data type to Boolean for all variables that begin with the letters in letterrange (for example, DefBool A-F). |
| DefByte letterrange | Sets the default data type to Byte for all variables that begin with the letters in letterrange . |
| DefCur letterrange | Sets the default data type to Currency for all variables that begin with the letters in letterrange . |
| DefDate letterrange | Sets the default data type to Date for all variables that begin with the letters in letterrange . |
| DefDbl letterrange | Sets the default data type to Double for all variables that begin with the letters in letterrange . |
| DefInt letterrange | Sets the default data type to Integer for all variables that begin with the letters in letterrange . |
| DefLng letterrange | Sets the default data type to Long for all variables that begin with the letters in letterrange . |
| DefObj letterrange | Sets the default data type to Object for all variables that begin with the letters in letterrange . |
| DefSng letterrange | Sets the default data type to Single for all variables that begin with the letters in letterrange . |
| DefStr letterrange | Sets the default data type to String for all variables that begin with the letters in letterrange . |
| DefVar letterrange | Sets the default data type to Variant for all variables that begin with the letters in letterrange . |
| DeleteSetting appname ,section , key | Deletes a section or key from the Registry. |
| Dim varname | Declares a variable named varname . |
| Do...Loop | Loops through one or more statements while a logical condition is True. |
| End keyword | Ends a procedure, function, or control structure. |
| Enum name | Module-level statement that declares an enumeration variable. |
| Erase arraylist | Frees the memory allocated to a dynamic array or reinitializes a fixed- size array. |
| Error errornumber | Simulates an error by setting Err to errornumber . |
| Event procedurename ( arglist ) | Class module-level statement that declares a user -defined event. |
| Exit keyword | Exits a procedure, function, or control structure. |
| FileCopy source, destination | Copies the source file to destination . |
| For Each...Next | Loops through each member of a collection. |
| For...Next | Loops through one or more statements until a counter hits a specified value. |
| Function | Declares a user-defined function procedure. |
| Get # filenumber, varname | Reads an I/O file opened by the Open statement into a variable. |
| GoSub...Return | Branches to and returns from a subroutine within a procedure. (However, creating separate procedures makes your code more readable.) |
| GoTo line | Sends the code to the line label given by line . |
| If...Then...Else | Runs one of two sections of code based on the result of a logical test. |
| Implements InterfaceName, Class | Specifies the name of an interface or a class to be implemented in a class module. |
| Input # filenumber, varlist | Reads data from an I/O file into variables. |
| Kill pathname | Deletes the file pathname from a disk. |
| Let varname = expression | Sets the variable varname equal to expression . Let is optional and is almost never used. |
| Line Input # filenumber, var | Reads a line from an I/O file and stores it in var . |
| Load | Loads a user form into memory without displaying it. |
| Lock # filenumber , recordrange | Controls access to an I/O file. |
| LSet stringvar = string | Left-aligns a string within a String variable. |
| LSet var1 = var2 | Copies a variable of one user-defined type into another variable of a different user-defined type. |
| Mid | Replaces characters in a String variable with characters from a different string. |
| MidB | Replaces byte data in a String variable with characters from a different string. |
| MkDir path | Creates the directory (folder) named path . |
| Name oldpathname As newpathname | Renames a file or directory (folder). |
| On Error | Sets up an error-handling routine. |
| On...GoSub, On...GoTo | Branches to a line based on the result of an expression. |
| Open pathname , etc. | Opens an input/output (I/O) file. |
| Option Base 01 | Determines (at the module level) the default lower bound for arrays. |
| Option Compare TextBinary | Determines (at the module level) the default mode for string comparisons. |
| Option Explicit | Forces you to declare all variables used in a module. Enter this statement at the module level. |
| Option Private | Indicates that the module is private and can't be accessed by other procedures outside the module. Enter this statement at the module level. |
| Print # filenumber | Writes data to an I/O file. |
| Private varname | Declares the varname variable to be a private variable that can be used only in the module in which it's declared. Enter this statement at the module level. |
| Property Get | Declares a property procedure. |
| Property Let | Assigns a value to a property in a property procedure. |
| Property Set | Sets a reference to an object in a property procedure. |
| Public varname | Makes the varname variable available to all procedures in a module. |
| Put # filenumber, varname | Writes data from the variable varname to an I/O file. |
| RaiseEvent eventname , arguments | Fires the event given by eventname . |
| Randomize number | Initializes the random-number generator. Omit number to get a different random number each time. |
| ReDim varname | Reallocates memory in a dynamic array. |
| Rem comment | Tells VBA that the following text is a comment. The apostrophe (') is more widely used. |
| Reset | Closes all I/O files that were opened with Open . |
| Resume | After an error, resumes program execution at the line that caused the error. |
| RmDir path | Deletes a directory (folder). |
| RSet stringvar = string | Right-aligns a string within a String variable. |
| SaveSetting appname , etc. | Creates or saves a setting in the Windows Registry. |
| Seek # filenumber, position | Sets the current position in an I/O file. |
| Select Case | Executes one of several groups of statements based on the value of an expression. |
| SendKeys string, wait | Sends the keystrokes given by string to the active application. |
| Set objectvar = object | Assigns an object to an Object variable named objectvar . |
| SetAttr pathname, attr | Assigns the attributes given by attr (for example, vbReadOnly ) to the file given by pathname . |
| Static varname | Declares varname to be a variable that will retain its value as long as the code is running. |
| Stop | Places VBA in Pause mode. |
| Sub | Declares a procedure. |
| Time = time | Sets the system time to time . |
| Type varname | Declares a user-defined data type. (Used at the module level only.) |
| Unload | Removes a user form from memory. |
| Unlock # filenumber , recordrange | Removes access controls on an I/O file. |
| While...Wend | Loops through a block of code while a condition is True. |
| Width # filenumber, width | Assigns an output line width to an I/O file. |
| With...End With | Executes a block of statements on a specified object. |
| Write # filenumber | Writes data to an I/O file. |
