Variable Manipulation Quick Reference
The following table lists methods to manipulate variables.
Statement | Purpose | Reference |
---|---|---|
Deftype |
Sets the default data type for one or more variables. |
|
Dim |
Declares a variable. |
|
Global |
Declares a global variable. |
|
Let |
Assigns a value to a variable. |
|
Null |
Sets a variant variable to a value of Null. |
|
Option Explicit |
Forces you to explicitly declare every variable in a module. |
|
Static |
Declares a variable and allocates storage space for this variable. |
|
VarType |
Returns the type of data stored in a variant. |
|
With |
Runs a series of statements on a variable. |