Variables

The following Visual Basic commands have been tested with IDEA v9 and appear to be functioning properly. I have added some examples where possible on their use.

Nothing

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:48

There are situations where an object variable does not refer to any object: It refers to nothing, and VBA has the special keyword Nothing to represent this. An object variable contains Nothing when it has been declared but not yet initialized (has not been assigned an object reference).

Finally, you can (and should) explicitly set an object reference to Nothing when you are finished using the object

Object

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:50

The Object data type can hold a reference to any object.  Using object any type of object can be referenced while you can reference specific types of objects with they type of object, such as referencing a database as a database object or a task as a task object.

Single

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:52

Name: Single

Type: Floating point

Range: -3.4 × 1038 to 3.4 × 1038 approximately

Precision: 6 digits

Static Arrays

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:40

A static array has a fixed size or number of elements. You specify the array size when you declare it, and the size cannot change during program execution.  The size will be one more than n because VBA array indexes start by default at 0.

You can use an integer variable or constant as the index.

String

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:50

String variables are used to hold text data.  A fixed-length string can be declared to contain anywhere from 1 to about 64,000 characters.  To declare a fixed-length string, use the String keyword followed by the * (asterisk) symbol and the desired size.

TypeName()

Brian Element's picture
Submitted by Brian Element on Tue, 08/28/2012 - 06:55

Need to add explanation.

User-Defined Types

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:49

A user-defined type (UDT) allows the programmer to define custom data elements that are specifically suited for the data at hand. A UDT can contain two or more elements, each element being a variable or array. UDTs are defined with the Type...End Type statement.

Variant

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:49

Variant is VBA’s most flexible data type as well as the default type. The Variant data type can hold almost any type of data, the exceptions being fixedlength strings and user-defined types. The downside is that Variant data requires more memory to store, and more computer power to process, than other data types.

VarType()

Brian Element's picture
Submitted by Brian Element on Tue, 08/28/2012 - 06:54

Need to add explanation

Pages