Do...Loop Statement
Repeats a section of code while or until a condition is met
Exit Statement
Branches to the next line of code outside of the currently executing structure
For Each...Next Statement
Iterates through a collection or array of objects or values, returning a reference to each to the members
For...Next Statement
Iterates through a section of code a given number of times
Friend Statement
Declares the procedure or variable to have scope only within the project in which it is defined
Function Statement
Defines a prototype for a procedure that returns a value
If...Then...Else Statement
Defines a conditional block or blocks of code
Private Statement
Declares the procedure or variable to have scope only within the module in which it is defined
Property Get Statement
Defines a prototype for a property procedure that returns a value
Property Let Statement
Defines a prototype for a property procedure that accepts a value
Defines a prototype for a property procedure that sets a reference to an object
Public Statement
Declares the procedure or variable to have scope within the module and project in which it is defined and, if declared within an object module, to have scope outside the current project
A series of code blocks, only one of which will execute based on a given value
Sub Statement
Declares a prototype for a procedure that does not return a value or an event-handling procedure
While...Wend Statement
Repeats a section of code while or until a condition is met
With...End With Statement
Allows the implicit use of an object reference
WithEvents Keyword
Denotes that the current module will handle events fired by the specified object